Howdy:
Running PostgreSQL 7.2.1 on RedHat Linux 7.2.
Is there a way to get a tables age from within the
database?
What I mean is, I know that I have created a list of temporary
tables, but I may not know what they are. I would like to
create a script that drops those tables by a date parameter
(if the age of t_table is > 60 days; drop t_table) rather than
dropping the tables by name association (t_table).
Suggestions? Comments?
Thanks!
-X