> 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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
