Re: Rollback table data.

[Moreno Andreo <moreno.andreo@xxxxxxxxxx>]

Il 07/06/2017 13:33, Dinesh Chandra 12108 ha scritto:

Dear Expert,

 

Is there any way to rollback table data in PostgreSQL?

Not knowing anything else about your what you want to do and what context you're in, I can only say that AFAIK, once you COMMITted a transaction, no rollback is possible.

A very quick google search gave me this:
https://stackoverflow.com/questions/12472318/can-i-rollback-a-transaction-ive-already-committed-data-loss

There's a long, detailed post from Craig Ringer that gives you some advise on how to proceed (given that a committed transaction cannot be ROLLBACKed)

Take a look, I hope it's applicable to your scenario.

HTH
Moreno.-