Re: Example of insert into Postgresql

[allan juul]

Quoting Ruben Montes <[EMAIL PROTECTED]>:

> Hello,
> 
> can anybody give an example that works of a insert statement to a
> postgresql
> database using perl DBI?
> 
> Thanks in advance,
> 
> Ruben

something like this  ?
./allan

##########################
use constant DBNAME             => "dbi:Pg:dbname=nameofdb";
use constant DBUSER             => "user";
use constant DBPASS             => "pw";

my $dbh = DBI->connect(FOF_C::DBNAME, FOF_C::DBUSER, FOF_C::DBPASS, {
        AutoCommit => 1,
        PrintError => 1,
        RaiseError => 0,
});

my $sql = "insert into $table (id, name) values (?,?)";
my $sth = $dbh->prepare( $sql );
$sth->execute(243, "joe");
$sth->finish();

$dbh->disconnect();