Re: Storing Binary Large Objects

On Mar 29, 2007, at 08:35, Mark Wong wrote:

> On paper, using bytea looks more straightforward the oid datatype.
> Does bytea have its own difficulties, other than having to find a way
> to escape the data?

Only that it's not chunked, so when you do a select, you get the
entire data back, not just a pointer. That's the primary difference,
AFAIK.

Tools like DBD::Pg do the escaping for you, provided you tell them
that it's bytea:

my $sth = $dbh->prepare('INSERT INTO foo (bytea_col) VALUES(?)');
$sth->bind_param(1, $binary_data, { pg_type => DBD::Pg::PG_BYTEA });
$sth->execute;

Best,

David