Search Postgresql Archives

Re: How to find the number of rows deleted

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



At least, you can do a "select count(*) from ..." just before the delete, better if inside a transaction, if the query itself is not too much expensive

Andrus wrote:

I ran DELETE command from my ODBC client application.
I want to get the number of rows deleted by this DELETE command.

I read the DELETE command docs but havent found any function.

Any idea ?

Andrus.


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq





---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux