my $value = "111";
$dbh->do("insert into foo(id, test) values (8, ?)", undef, $value);

##</code><code>##

foobar=> select lo_export('test', '/tmp/x') from foo where id=8;
ERROR:  pg_atoi: error in "test": can't parse "test"