Re: view the previous version of tables

[Ashutosh Sharma <ashu.coek88@xxxxxxxxx>]

Please try installing pageinspect extension and re-run the queries. You amy refer to the following URL for reference,

https://paquier.xyz/postgresql-2/postgres-contrib-module-highlight-pageinspect/

But, please note that you will only be able to see the deleted or updated rows if they still exist in the page. If VACUUM has already cleaned those then you won't be able to see it.

--
With Regards,
Ashutosh Sharma
EnterpriseDB:http://www.enterprisedb.com

On Fri, Apr 17, 2020 at 6:14 PM Ankush Chawla <ankushchawla03@xxxxxxxxx> wrote:

What is the command to view the previous version of rows (deleted or updated)

I searched and found some functions like : . But none of them are working

 SELECT * FROM page_header(get_raw_page('school',0));

SELECT * FROM heap_page_items(get_raw_page('school',0));
                                  ^

Sorry for a basic question

--

Best Regards,
Ankush Chawla