Skip site navigation (1) Skip section navigation (2)

Re: status variables

From: "Keith Worthington" <keithw(at)narrowpathinc(dot)com>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: status variables
Date: 2004-12-15 03:39:56
Message-ID: (view raw or whole thread)
Lists: pgsql-novice
> On Tue, Dec 14, 2004 at 09:11:24PM -0500, Keith Worthington wrote:
> > When executing a query in PostgreSQL v7.3.6 are any variables
> > set that  indicate the status of that query?  Success/Failure,
> > Number of rows retrieved, Number of records written, etc.  If
> > not is this functionality provided in a later release?  Where
> > can I find the documentation that describes these variables?
> Whether query status is available and how to access it depends on
> the interface you're using (libpq, Perl + DBI, ECPG, PL/pgSQL, etc.)
> and should be described in that interface's documentation.  What
> interface are you using?
> -- 
> Michael Fuhr

Thanks again Michael.  You have once again given me a nudge in the right
direction.  I found what I needed at

I can now continue on towards my goal of writing a procedure to move data from
one table to another. :-)

Kind Regards,

99main Internet Services

In response to

pgsql-novice by date

Next:From: Lola LeeDate: 2004-12-15 11:31:57
Subject: Can't Access Pgsql 7.4.3 in phpPgAdmin on Mac OS X
Previous:From: Michael FuhrDate: 2004-12-15 03:00:24
Subject: Re: status variables

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group