How to identify when the table is created in postgres

Поиск
Список
Период
Сортировка
От mallikarjun t
Тема How to identify when the table is created in postgres
Дата
Msg-id CAOA8XiWRbAg1vtaL-AhO02N3SL6eMY6yM8KH-Po7SYiejgXw=w@mail.gmail.com
обсуждение исходный текст
Список pgsql-admin
Dear Team,

How to identify when the table is created in postgres database level, what time it is created that details, I want to know,

To know the when table is stored in data directory by knowing,

select pg_relation_filepath('table_name');

How many reltuples and relpages we can know for that table by using pg_class,

select relpages,reltuples,relname,oid from pg_class where relname='table_name';

When the table doing last vacuum and analyzing to know this one by using 

select *from pg_stat_user_tables where relname='table_name';

what date table is created, when last modified of that table to know details?

Kindly give you explanation of above query?

Regards,
Mallikarjunarao,
+91-8142923383.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Pepe TD Vo
Дата:
Сообщение: commit & rollback
Следующее
От: mallikarjun t
Дата:
Сообщение: How to know transaction count in hour basic