Thread: status variables
Hi All, 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? Kind Regards, Keith ______________________________________________ 99main Internet Services http://www.99main.com
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/
> 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