Search Postgresql Archives

table creation/modified timestamp

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux