Re: Adding modified and creation datetime to system catalogs

Thom Brown <thombrown@gmail.com> writes:
> I was looking around for ways to find out the creation date of a database or
> a table, but there doesn't appear to be any functions or available metadata
> to provide this information.  Unless there's a way I haven't seen yet, does
> anyone see any problem with adding a creationdatetime and modifieddatetime
> column to catalogs such as pg_database and pg_tables (but also maybe
> pg_views, pg_language, pg_type etc)?

This has been proposed before, and rejected before, many times.  Please
see the archives.

            regards, tom lane