It would really be nice if pg_class were altered to add two new columns:
relcreatedat & relmoddat.
Both would be of type timestamp. relcreatedat would contain the timestamp the
object was created.
Likewise, relmoddat would contain the last timestamp the object was altered /
modified.
This would be very useful for user tables that are meant to exist for only a
specific length of time. eg: 1 month.
Then a simple:
SELECT relname
FROM pg_class
WHERE current_timestamp::date - relcreatedat::date > 30
AND relname LIKE 'tmp_%';
Would show possible expired tables.
Likewise, relmoddat would be useful for determining when someone made changes
to a table, index, view, etc.
Melvin Davidson - DBA
Confidentiality Notice: This e-mail message (including any attached or
embedded documents) is intended for the exclusive and confidential use of the
individual or entity to which this message is addressed, and unless otherwise
expressly indicated, is confidential and privileged information of Rackspace.
Any dissemination, distribution or copying of the enclosed material is
prohibited.
If you receive this transmission in error, please notify us immediately by
e-mail
at ab...@rackspace.com, and delete the original message.
Your cooperation is appreciated.
