Status Checking

Hi!

Sorry for posting this simple question....

I'm just new to postgres and i'm using PERL interface to access my
databases.  I just want to know how can i check or get the status if my
query command has no errors.

     $dbh = Pg::connectdb("dbname=MMS");

How do i check if there's no error connecting to my database MMS?

     $sth = $dbh->exec("select syskey from syskey where syskey =                          '$syskey'");     $sth =
$dbh->exec("insertinto syskey values('$syskey', '$value',                     '$desc')");     $sth = $dbh->exec("delete
fromsyskey where val='test'");
 

How to i check if my select, insert and delete statement has no error?

Thanks...

George 

---------------------------------------------------------------------
|   George P. Esperanza                    e-mail : george@laguna.net |
|   Laguna Internet                        phone  : (049) 545-2358    |
|   6 East Arcade Calamba Trade Center                                |
|   Calamba, Laguna                                                   |
---------------------------------------------------------------------