Hello all,
I'm trying to load a large amount of binary data in bytea field in Postgre 
table using perl.
The problem is that the only way I've managed to do it was by using 
placeholders and binding like this:
  $statement="Insert into pic1 (pic,type) values(?,'eps2')";
  $sth=$dbh->prepare($statement);
  $sth->bind_param(1, "$md",SQL_QUERY ) || die $dbh->errstr;

Is there any "generic" way to write this statement in the "usual" way :
INSERT INTO table (col1,col2,...) VALUES (val1,val2,...).

I'm using Perl5.6.1 ;DBI 1.21 ;DBD:Pg 1.01; PostgreSQL 7.2.1 on Debian Linux 
mashine

10x in advance

Reply via email to