How to identify when the table is created in postgres

From: mallikarjun t <mallit333(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: How to identify when the table is created in postgres
Date: 2019-10-30 14:02:49
Message-ID: CAOA8XiWRbAg1vtaL-AhO02N3SL6eMY6yM8KH-Po7SYiejgXw=w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-admin by date

  From Date Subject
Next Message mallikarjun t 2019-10-30 14:13:17 How to know transaction count in hour basic
Previous Message Pepe TD Vo 2019-10-30 13:45:06 commit & rollback