how to get a table's age - Mailing list pgsql-general

From Johnson, Shaunn
Subject how to get a table's age
Date
Msg-id 73309C2FDD95D11192E60008C7B1D5BB04C746BD@snt452.corp.bcbsm.com
Whole thread Raw
List pgsql-general

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

pgsql-general by date:

Previous
From: Carlos Moreno
Date:
Subject: Re: libpq++ in 7.3?
Next
From: Medi Montaseri
Date:
Subject: Re: Can postgresql be run in memory (like a memory resident