Обсуждение: table creation/modified timestamp

Поиск
Список
Период
Сортировка

table creation/modified timestamp

От
Kevin Neufeld
Дата:
A wish-list feature for me is for postgresql to keep a record of a table
creation date and modified date.  This could be added to the '\dt+'
shortcut.

I have well over 100 tables and I find I'm always asking myself when
certain tables were created.  I realize I could always look at the
relfilenode attribute from pg_class and hunt around in the filesystem to
track down the datestamp the OS gave the file ... but a shortcut view
would be nice.

Cheers,
Kevin