From: | "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Time table was created / admin clean-up |
Date: | 2002-07-12 15:23:45 |
Message-ID: | 73309C2FDD95D11192E60008C7B1D5BB04C73CC4@snt452.corp.bcbsm.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Howdy:
Running PostgreSQL 7.1.3 on RedHat Linux 7.2
kernel 2.4.7 - rel. 10.
I'm looking for a way to find the age of a table and
then doing something (like dropping them) than the way
I'm going about it now. The tables I want to drop
are created by users and are prefixed as 't_'.
Now, I'm could go about it by hand:
[snip]
select oid from pg_class where relname ~* 't_';
[/snip]
From there, I'd go and look in the database directory
and see what the timestamp is and from there guess
that they were created / updated at that point.
I know I would probably be forgetting something and
breaking a dozen other things.
Is there an easier way to do this?
Thanks!
-X
From | Date | Subject | |
---|---|---|---|
Next Message | Jie Liang | 2002-07-12 15:29:55 | Re: [SQL] Please, HELP! Why is the query plan so wrong??? |
Previous Message | Thomas Lockhart | 2002-07-12 15:07:33 | Re: workaround for lack of REPLACE() function |