HI, If you dont vaccum the table, You can read data modified with pg_dirtyread extension, but be carefull ;-)
https://github.com/omniti-labs/pgtreats/tree/master/contrib/pg_dirtyread
Regards
On 07/06/17 07:33, Dinesh Chandra 12108 wrote:
Dear Expert,
Is there any way to rollback table data in PostgreSQL?
Regards,
Dinesh Chandra
|Database administrator (Oracle/PostgreSQL)| Cyient Ltd. Noida.
------------------------------------------------------------------
Mobile: +91-9953975849 | Ext 1078 |dinesh.chandra@cyient.com
Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India.
DISCLAIMER:
This email may contain confidential information and is intended only for the use of the specific individual(s) to which it is addressed. If you are not the intended recipient of this email, you are hereby notified that any unauthorized use, dissemination or copying of this email or the information contained in it or attached to it is strictly prohibited. If you received this message in error, please immediately notify the sender at Infotech or Mail.Admin@cyient.com and delete the original message.