> 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
>
