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: | 20041215033956.M66902@narrowpathinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
> http://www.fuhr.org/~mfuhr/
Thanks again Michael. You have once again given me a nudge in the right
direction. I found what I needed at
http://www.postgresql.org/docs/7.3/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS
I can now continue on towards my goal of writing a procedure to move data from
one table to another. :-)
Kind Regards,
Keith
______________________________________________
99main Internet Services http://www.99main.com
From | Date | Subject | |
---|---|---|---|
Next Message | Lola Lee | 2004-12-15 11:31:57 | Can't Access Pgsql 7.4.3 in phpPgAdmin on Mac OS X |
Previous Message | Michael Fuhr | 2004-12-15 03:00:24 | Re: status variables |