Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

Difficulty inserting a large object using DBD::Pg

by kudra (Vicar)
on Jun 29, 2000 at 15:46 UTC ( [id://20355] : perlquestion . print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
      
    my $sth = 
    $dbh->prepare("insert into foo(data) values (?);");
    $sth->bind_param(1, $value, SQL_LONGVARBINARY);
    $sth->execute();
    
  2. or download this
     
    SQL type 1075548612 for 'rc' is not fully supported, bound as VARCHAR 
    +instead at  ./1.0 line 122.
    
  3. or download this
    $dbh->prepare("insert into foo(data) values 
    (lo_import('/tmp/lame'));")