metadata about creation and size of tables

Поиск
Список
Период
Сортировка
От Martin Mueller
Тема metadata about creation and size of tables
Дата
Msg-id E6E0C150-E1A4-44BC-99E0-12395DEE6BE3@northwestern.edu
обсуждение исходный текст
Ответы Re: metadata about creation and size of tables  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список 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?

 

 

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

Предыдущее
От: Carl Sverre
Дата:
Сообщение: Re: Postgres trigger side-effect is occurring out of order withrow-level security select policy
Следующее
От: David Gauthier
Дата:
Сообщение: How can I get and handle the status of sql statements that run inplpgsql ?