RE: Re: Storing images in PG? - Mailing list pgsql-general

From Andrew SNow
Subject RE: Re: Storing images in PG?
Date
Msg-id 000001c12630$c9ab7fb0$fa01b5ca@avon
Whole thread Raw
In response to Re: Re: Storing images in PG?  (Tod McQuillin <devin@spamcop.net>)
Responses Re: Re: Storing images in PG?  (Karel Zak <zakkr@zf.jcu.cz>)
List pgsql-general
>  Yes, but good is encode binary data (image) to same ascii safe
> encoding like base64, else you will have problem in INSERT/UPDATE
> queries.

Correct me if I'm wrong, but the only thing "lztext" can't store is
NULLs, which could escaped somehow with other (rare) characters.  Still
overhead, but you shouldn't be storing large pieces of binary data this
way, I think.


- Andrew



pgsql-general by date:

Previous
From: Tod McQuillin
Date:
Subject: Re: Re: Storing images in PG?
Next
From: Karel Zak
Date:
Subject: Re: Re: Storing images in PG?