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:
data=> update tblTests set resultsArchive=lo_import('/temp/stuff.txt') where idTest = 161; ERROR: column "resultsarchive" of relation "tbltests" does not exist LINE 1: update tblTests set resultsArchive=lo_import('/temp/stuff....
I've googled for examples and I see nothing that would make me think this is not correct. Useful help would be greatly appreciated.
- Joe
In article BAY117-DAV14A0BD413911874E1F9CD49B080@phx.gbl, Joe Tseng fedora-list@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.