how to get a table's age

From: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: how to get a table's age
Date: 2003-02-25 18:29:58
Message-ID: 73309C2FDD95D11192E60008C7B1D5BB04C746BD@snt452.corp.bcbsm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Medi Montaseri 2003-02-25 19:06:30 Re: Can postgresql be run in memory (like a memory resident
Previous Message Carlos Moreno 2003-02-25 17:46:35 Re: libpq++ in 7.3?