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 rod@xxxxxx Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------
