[OT] Saving file as blob in PgSQL

[Rick Ellis]

In article <BAY117-DAV14A0BD413911874E1F9CD49B080 at phx.gbl>,
Joe Tseng <fedora-list at redhat.com> wrote:

>Has anyone written code to save files in PgSQL in a BLOB field?
>I can't seem to get it to play with my file... I created a new
>column named resultsArchive of type "bytea" and psql won't play
>nice:

One easy way is to just base64 encode the file data and store it
in a text field.

--
http://www.spinics.net/lists/