Binary data in PostgreSQL - Mailing list pgsql-general

From Holger Marzen
Subject Binary data in PostgreSQL
Date
Msg-id Pine.LNX.4.58.0402211948400.6070@bluebell.marzen.de
Whole thread Raw
Responses Re: Binary data in PostgreSQL  ("Uwe C. Schroeder" <uwe@oss4u.com>)
Re: Binary data in PostgreSQL  ("Gavin M. Roy" <gmr@ehpg.net>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Slow queries in PL/PGSQL function
Next
From: Franco Bruno Borghesi
Date:
Subject: Re: Post gresql commands