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

pgsql: Return the number of rows processed when COPY is executedthroug

From: Heikki Linnakangas <heikki(dot)linnakangas(at)iki(dot)fi>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Return the number of rows processed when COPY is executedthroug
Date: 2012-10-03 11:38:44
Message-ID: E1TJNHo-0006bj-W3@gemulon.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Return the number of rows processed when COPY is executed through SPI.

You can now get the number of rows processed by a COPY statement in a
PL/pgSQL function with "GET DIAGNOSTICS x = ROW_COUNT".

Pavel Stehule, reviewed by Amit Kapila, with some editing by me.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/7ae1815961c635fd1a6fe72acb89fdef741a45a8

Modified Files
--------------
doc/src/sgml/spi.sgml      |    5 ++++-
src/backend/executor/spi.c |   24 +++++++++++++++---------
2 files changed, 19 insertions(+), 10 deletions(-)

pgsql-committers by date

Next:From: Heikki LinnakangasDate: 2012-10-03 12:49:33
Subject: pgsql: Add --sampling-rate option to pgbench.
Previous:From: Heikki LinnakangasDate: 2012-10-03 06:17:05
Subject: Re: pgsql: Split off functions related to timeline history files and XLOG a

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