Thread: view the previous version of tables
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
Ankush Chawla
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.
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 workingSELECT * FROM page_header(get_raw_page('school',0));SELECT * FROM heap_page_items(get_raw_page('school',0));
^Sorry for a basic questionBest Regards,
Ankush Chawla