Hello
Does anybody has already programmed the way of using the "COPY FROM"
function from postgres, I try producing the following code:
my ($dbh, $sth10);
$dbh = DBI->connect("dbi:Pg:dbname=$database", "$username", "$password")
or die "Error: $DBI::errstr \n";
$sth10 = $dbh->prepare ("COPY dummy FROM /home/postgres/dummy/dummyfile");
$sth10->execute () or die "$DBI::errstr\n";
$sth10 = $dbh->disconnect();
But I get the following error:
DBD::Pg::st execute failed: ERROR: syntax error at or near "/" at character
61
at script-copy.pl line 17 (#1)
DBD::Pg::st execute failed: ERROR: syntax error at or near "/" at character
61 at script-copy.pl line 17.
ERROR: syntax error at or near "/" at character 61 (#1)
Uncaught exception from user code:
ERROR: syntax error at or near "/" at character 61
at script-copy.pl line 17
bash-2.03$
Thanks in advanced!!
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
