Re: Adding modified and creation datetime to system catalogs - Mailing list pgsql-general

From Tom Lane
Subject Re: Adding modified and creation datetime to system catalogs
Date
Msg-id 17172.1254490754@sss.pgh.pa.us
Whole thread Raw
In response to Adding modified and creation datetime to system catalogs  (Thom Brown <thombrown@gmail.com>)
Responses Re: Adding modified and creation datetime to system catalogs
List pgsql-general
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

pgsql-general by date:

Previous
From: Thom Brown
Date:
Subject: Adding modified and creation datetime to system catalogs
Next
From: Tom Lane
Date:
Subject: Re: Programming interfaces when using MD5 authentication