From: | Jonathan Bartlett <johnnyb(at)eskimo(dot)com> |
---|---|
To: | Terence Ng <ngterry2000(at)yahoo(dot)com(dot)hk> |
Cc: | pgsql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: How do I manage PDF file |
Date: | 2003-07-23 14:20:21 |
Message-ID: | Pine.GSU.4.44.0307230718540.27487-100000@eskimo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Franco Bruno Borghesi | 2003-07-23 14:21:19 | Re: 0/1 vs true/false |
Previous Message | Shridhar Daithankar | 2003-07-23 14:19:00 | Re: How do I manage PDF file |