Getting affected rows in pgplsql
I'm writing some ETL procedures in pgplsql. After each
insert/update/delete, I'd like to log how many rows were affected.
I'm not finding anything on Google. Does anyone know how to get this?
Maybe this will be helpfull:
Regards,
Blazej Oleszkiewicz
2008/9/4 Artacus <artacus@comcast.net>:
Show quoted text
I'm writing some ETL procedures in pgplsql. After each insert/update/delete,
I'd like to log how many rows were affected.I'm not finding anything on Google. Does anyone know how to get this?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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
That's just what I needed. Thanks guys!
Artacus
Show quoted text
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"