Answer Posted / Gaurav Bhatt
To find the creation date of a table in PostgreSQL, you can use the ``psql`" command-line tool and run the following query: ``SELECT tablename, tableattribs->'table_catalog' AS catalog,n tableattribs->'table_schema' AS schema,n tableattribs->'table_name' AS tablename,n pg_get_table_def(tablename) AS definitionnFROM pg_catalog.pg_tables,n (SELECT relname, tablename FROM pg_catalog.pg_depend WHERE objid = OBJECT_ID('public.your_table')) AS tableattribs`". The creation date should be visible in the table definition.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
