[GENERAL] Table create time

Поиск
Список
Период
Сортировка
Искать
От
hamann.w@t-online.de
Тема
[GENERAL] Table create time
Дата
Msg-id
wolfgang-1170831085609.A016879@noten19.local
Список
Дерево обсуждения
[GENERAL] Table create time hamann.w@t-online.de
Re: [GENERAL] Table create time "Charles Clavadetscher" <clavadetscher@swisspug.org>
Re: [GENERAL] Table create time "David G. Johnston" <david.g.johnston@gmail.com>
Re: [GENERAL] Table create time Melvin Davidson <melvin6925@gmail.com>
Re: [GENERAL] Table create time Tom Lane <tgl@sss.pgh.pa.us>
Re: [GENERAL] Table create time Melvin Davidson <melvin6925@gmail.com>
Re: [GENERAL] Table create time Michael Paquier <michael.paquier@gmail.com>
Re: [GENERAL] Table create time Melvin Davidson <melvin6925@gmail.com>
Re: [GENERAL] Table create time Achilleas Mantzios <achill@matrix.gatewaynet.com>
Re: [GENERAL] Table create time Melvin Davidson <melvin6925@gmail.com>
Re: [GENERAL] Table create time Melvin Davidson <melvin6925@gmail.com>
Re: [GENERAL] Table create time Michael Paquier <michael.paquier@gmail.com>
Re: [GENERAL] Table create time Achilleas Mantzios <achill@matrix.gatewaynet.com>
Re: [GENERAL] Table create time hamann.w@t-online.de
Re: [GENERAL] Table create time Achilleas Mantzios <achill@matrix.gatewaynet.com>
Re: [GENERAL] Table create time Achilleas Mantzios <achill@matrix.gatewaynet.com> 

Hi,

is there a way to add a table create (and perhaps schema modify) timestamp to the system?
I do occasionally create semi-temporary tables (meant to live until a problem is solved, i.e. longer
than a session) with conveniently short names.
Also, is there a simple query to identify tables without a table comment? (so a weekly cron
could remind me of tables that are already a few days old but have no explanatory comment)

I am running PG 9.3

Best regards
Wolfgang Hamann
В списке pgsql-general по дате отправления
Предыдущее
От: Thomas Kellerer
Дата:
Следующее
От: Charles Clavadetscher
Дата:
FAQ