Help for this page

Select Code to Download


  1. or download this
    ...
    my $data_file = "data.tsv";
    ...
    my $s2 = "\copy (" . $tableName . ") FROM '" . $data_file . "'";
    $dbh->do($s2);
    ...
    
  2. or download this
    DBD::Pg::db do failed: ERROR:  syntax error at or near ""
    LINE 1: py (testingtable) FROM 'data.tsv'
            ^ at ./dbcopy.pl line 48.