Does the bytea make its own files automatically for large objects?
Also, how about backups with tables having bytea columns.?
Jonathan Bartlett wrote:
Also, if I wanted to put a *.pdf file in a bytea column, what functions
do I use to escape any characters in it?
What programming language are you using?
In Perl, you do something like:
$sth->bind_param(1, $file_data, DBI::SQL_BINARY); #DBI::SQL_BINARY is deprecated, but it works
In php you do:
$file_data = pg_escape_bytea($file_data);
$db->query("insert into blah(blahh) values ('${file_data}'::bytea);
To retrieve the info in Perl, it's just a regular fetchrow()
my ($file_data) = $sth->fetchrow();
In php, you have to run stripcslashes() on the data.
list($file_data) = $query->fetchrow(); $file_data = stripcslashes($file_data);
Jon
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
