Re: Rollback table data.

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
>