From: | Martin Mueller <martinmueller(at)northwestern(dot)edu> |
---|---|
To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | metadata about creation and size of tables |
Date: | 2018-10-02 20:38:36 |
Message-ID: | E6E0C150-E1A4-44BC-99E0-12395DEE6BE3@northwestern.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I’ve looked at the documentation to find where to find some data that are very to find Mysql: the creation and modification data of a table and the size of particular tables.
Where do I find an answer to the question “which is the last table I created” or “when did I last modify this table?” In the data directory, tables seem to have numbers, but there doesn’t seem to be an easy mapping of those numbers to the table names.
I thumbed through the documentation, but didn’t see any heading that was likely to have that information. Is there some where a “table of tables” that lets you look up various metadata?
From | Date | Subject | |
---|---|---|---|
Next Message | David Gauthier | 2018-10-02 20:47:22 | How can I get and handle the status of sql statements that run in plpgsql ? |
Previous Message | Carl Sverre | 2018-10-02 19:12:32 | Re: Postgres trigger side-effect is occurring out of order with row-level security select policy |