Re: view the previous version of tables

Поиск
Список
Период
Сортировка
От Ashutosh Sharma
Тема Re: view the previous version of tables
Дата
Msg-id CAE9k0Pm0eH8oCFBxBjL6tUDdfzXzx9UDpPv6GWL1bnNwX7exAA@mail.gmail.com
обсуждение исходный текст
Ответ на view the previous version of tables  (Ankush Chawla <ankushchawla03@gmail.com>)
Список pgsql-admin
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Ankush Chawla
Дата:
Сообщение: view the previous version of tables
Следующее
От: Arnav
Дата:
Сообщение: VACUUM freeze