Re: store data files encryptypted in database.
Raymond O'Donnell <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.php |
|---|---|
| Message-ID | <[email protected]> |
On 10/10/2008 16:32, elmarkivp wrote: > $sql = "INSERT INTO SOME_TABLE (bytea_file) VALUES > (pgp_sym_decrypt_bytea($file,somepass,cipher-algo=aes256))"; > pg_query($link, $sql) or die(pg_last_error($link)); > > this error appear... > > ERROR: column "content_of_bytea_file" does not exist ( > "content_of_bytea_file" is $file) At a guess, you need to quote the contents of $file in order to get PG to treat it as a string. If you don't, PG sees it as a column name, hence the error you're seeing. Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland [email protected] Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-php mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-php