Message-ID: <378963DA.768C173E@lee.k12.nc.us>
Date: Sun, 11 Jul 1999 23:41:15 -0400
From: James Olin Oden <joden@lee.k12.nc.us>
MIME-Version: 1.0
To: "George P. Esperanza" <george@calamba.laguna.net>
CC: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Status  Checking
References: <Pine.LNX.4.05.9907120823360.20680-100000@calamba.laguna.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

> 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?
>

All of these questions can be answered by typing:

   man Pg

and reading the text.

Cheers...james

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