Postgres Pro
Downloads
Home   >   mailing lists

Re: Getting affected rows in pgplsql - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: Getting affected rows in pgplsql
Date
Msg-id 20080904110844.GA32685@depesz.com
Whole thread Raw
In response to Getting affected rows in pgplsql  (Artacus <artacus@comcast.net>)
Responses Re: Getting affected rows in pgplsql  (Artacus <artacus@comcast.net>)
List pgsql-general
Tree view 
On Thu, Sep 04, 2008 at 02:07:01AM -0700, Artacus wrote:
> I'm writing some ETL procedures in pgplsql. After each
> insert/update/delete, I'd like to log how many rows were affected.

http://www.postgresql.org/docs/current/interactive/plpgsql-statements.html
search for "GET DIAGNOSTICS"

Best regards,

depesz

--
Linkedin: http://www.linkedin.com/in/depesz  /  blog: http://www.depesz.com/
jid/gtalk: depesz@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007

pgsql-general by date:

Previous
From: Blazej
Date:
Subject: Re: Getting affected rows in pgplsql
Next
From: "Roberts, Jon"
Date:
Subject: Re: Oracle and Postgresql