From: James Olin Oden <joden@lee.k12.nc.us>
To: George P. Esperanza <george@calamba.laguna.net>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Status Checking
Date: Sun, 11 Jul 1999 23:41:15 -0400
Message-ID: <378963DA.768C173E@lee.k12.nc.us> (raw)
References: <Pine.LNX.4.05.9907120823360.20680-100000@calamba.laguna.net>
> 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 |
> ---------------------------------------------------------------------
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: joden@lee.k12.nc.us, george@calamba.laguna.net
Subject: Re: [INTERFACES] Status Checking
In-Reply-To: <378963DA.768C173E@lee.k12.nc.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox