metadata about creation and size of tables

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?

Responses

Browse pgsql-general by date

  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