[OT] Saving file as blob in PgSQL
- From: "Joe Tseng" <joe_tseng@xxxxxxxxxxx>
- Date: Fri, 29 Jun 2007 16:17:57 -0400
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--
fedora-list mailing list
fedora-list@xxxxxxxxxx
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
- Follow-Ups:
- Re: [OT] Saving file as blob in PgSQL
- From: Rick Ellis
- Re: [OT] Saving file as blob in PgSQL
- Prev by Date: Re: xdcmp connection with xming
- Next by Date: Re: selinux eradicator?
- Previous by thread: Grub inacuracies
- Next by thread: Re: [OT] Saving file as blob in PgSQL
- Index(es):
