Thread: request info on data recovery in pgsql

request info on data recovery in pgsql

From
Sameer N Navaratna
Date:
Hi,
    While working on a postgresql db table, I accidentally updated 929
records. Can you please tell me how to get back the previous data. The
query I executed was like this:
    update stat_details set accomplishments='executed test case for
eTracker';
stat_details contained 929 records and all were updated because I forgot
to put the where clause.
Please help me out. Will you?
Thanks,
Sameer