Re: Binary data in PostgreSQL

It's not the most effective use of space, and I'm sure not the best way
to do it, but I store such data as base64 encoded text. Works very
well for my needs, in that regard.

Gavin

Holger Marzen wrote:

>Hi all,
>
>AFAIK it is possible for columns to be very large, up to about 2 GB. Are
>there any hints or experiences about storing binary data (jpg-images,
>pdf-documents) in PostgrreSQL with or without the complicated lo-stuff?
>
>Of course it's in many cases a good approach to store those files simply
>in the file system but there's always a risk of running out of sync
>(filesystem and tables), e.g. by deleting files and not deleting the
>table rows with the filenames.
>
>Any ideas and comments welcome.
>
>---------------------------(end of broadcast)---------------------------
>TIP 7: don't forget to increase your free space map settings
>
>