Re: is there a function in postgresql that can be used for retrieving deleted rows

[David Johnston <polobo@xxxxxxxxx>]

On Oct 22, 2011, at 1:23, "Charles Waweru" <cwaweru@xxxxxxxxxxxxxxxxxx> wrote:

I am looking for a tool in the PostgreSQL database that can help to audit fraudulent activities on a PostgreSQL database. Of particular interest is how to retrieve say from a PostgreSQL sales database all the deleted rows.

 

Any suggestion please would be appreciated.

 

Charles

You have to manually save the row to an archive table prior to deleting it.  Once you have deleted a row from a table you cannot get it back.

There are multiple options to choose from to implement such an archive process.

David J.