Re: How to find the number of rows deleted - Mailing list pgsql-general

From Ropel
Subject Re: How to find the number of rows deleted
Date
Msg-id 42DB90F7.7070805@ropel.it
Whole thread Raw
In response to How to find the number of rows deleted  ("Andrus" <eetasoft@online.ee>)
List pgsql-general
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
>
>
>
>



pgsql-general by date:

Previous
From: Janning Vygen
Date:
Subject: Changes to not deferred FK in 8.0.3 to 7.4?
Next
From: "David Esposito"
Date:
Subject: Re: index bloat