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
