view the previous version of tables

From: Ankush Chawla <ankushchawla03(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: view the previous version of tables
Date: 2020-04-17 12:43:49
Message-ID: CAOY8JhDzDM=Y1WK02EspDoG+xfJOvQRpVBdT6AgzYQo2jSyJ7Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ashutosh Sharma 2020-04-17 12:56:28 Re: view the previous version of tables
Previous Message Holger Jakobs 2020-04-17 12:39:49 Re: catalog views to check on grants