Re: How do I manage PDF file - Mailing list pgsql-general

From Jonathan Bartlett
Subject Re: How do I manage PDF file
Date
Msg-id Pine.GSU.4.44.0307230718540.27487-100000@eskimo.com
Whole thread Raw
In response to How do I manage PDF file  (Terence Ng <ngterry2000@yahoo.com.hk>)
Responses Re: How do I manage PDF file  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
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
>


pgsql-general by date:

Previous
From: Franco Bruno Borghesi
Date:
Subject: Re: 0/1 vs true/false
Next
From: "Claudio Lapidus"
Date:
Subject: Re: 0/1 vs true/false