Hi Dinesh,
Le 07/06/2017 à 14:48, Andreas Kretschmer a écrit :
>
>
> Am 07.06.2017 um 13:33 schrieb Dinesh Chandra 12108:
>>
>> Dear Expert,
>>
>> Is there any way to rollback table data in PostgreSQL?
>>
>>
> if you are looking for somewhat similar to flashback in oracle the
> answer is no.
>
Well, if this is what you are looking for, the E-Maj extension may help
you. In few words, it allows 1) to log updates on tables sets (using
triggers), 2) to set marks on these tables sets when they are in a
stable state and 3) to travel back and forth to these marks.
Some pointers:
- pgxn to download a stable version : https://pgxn.org/dist/e-maj/ (the
downloadable zip file also contains a presentation that may help to
quickly get a good view of the extension - doc/emaj.2.0.1_doc_en.pdf)
- on-line documentation : http://emaj.readthedocs.io/
- github projects : https://github.com/beaud76/emaj and
https://github.com/beaud76/emaj_ppa_plugin
Best regards. Philippe.
> Regards, Andreas
>