Re: How do I manage PDF file

You can store them in the filesystem or in PostgreSQL.  In PostgreSQL, you
can either store them as BLOBs or bytea columns.  I prefer bytea columns
for numerous reasons.  The only reason I can think of to use a BLOB is if
you only want to return _part_ of the file.

Jon

On Wed, 23 Jul 2003, [iso-8859-1] Terence Ng wrote:

> Hi,
>
> For a catalogue, one or more products are described by
> a PDF file regarding to the specification of the
> products. And there are many files.
>
> How should I manage these PDF files?  Could I store
> these files to PostgreSQL or I can only store the
> links to these files?
>
> Best regards,
> Terence
>
> _______________________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com.hk address at http://mail.english.yahoo.com.hk
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>