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("insert into syskey values('$syskey', '$value',
'$desc')");
$sth = $dbh->exec("delete from syskey 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(at)laguna(dot)net |
| Laguna Internet phone : (049) 545-2358 |
| 6 East Arcade Calamba Trade Center |
| Calamba, Laguna |
---------------------------------------------------------------------