Postgres Pro
Downloads
Home   >   mailing lists

Re: view the previous version of tables - Mailing list pgsql-admin

From Ashutosh Sharma
Subject Re: view the previous version of tables
Date
Msg-id CAE9k0Pm0eH8oCFBxBjL6tUDdfzXzx9UDpPv6GWL1bnNwX7exAA@mail.gmail.com
Whole thread Raw
In response to view the previous version of tables  (Ankush Chawla <ankushchawla03@gmail.com>)
List pgsql-admin
Tree view
Please try installing pageinspect extension and re-run the queries. You amy refer to the following URL for reference,


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@gmail.com> 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

pgsql-admin by date:

Previous
From: Ankush Chawla
Date:
Subject: view the previous version of tables
Next
From: Arnav
Date:
Subject: VACUUM freeze