Re: How do I manage PDF file

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: How do I manage PDF file
Date: 2003-07-23 15:56:33
Message-ID: 20030723175633.A585@hermes.hilbert.loc
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.
And even that can be done with substr() which I have used to
allow for chunked fetching of BLOBs over socket
implementations that die when overloaded (due to faulty flow
control).

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346

In response to

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-07-23 16:02:46 Re: 0/1 vs true/false
Previous Message Cory 'G' Watson 2003-07-23 15:56:12 Re: Increasing Max # of connections