From: | Mary Anderson <maryfran(at)demog(dot)berkeley(dot)edu> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Systems view which gives creation date for a table? |
Date: | 2008-11-17 16:53:25 |
Message-ID: | 4921A185.1040206@demog.berkeley.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi all,
I would like to be able to query some systems table or view to
obtain the creation data of a table. INFORMATION_SCHEMA does not seem
to record this information. Does postgres store it somewhere?
I need this for a PHP/postgres application which creates temporary
tables which should be cleaned up when my application finishes. But
sometimes they aren't., so I have to write code to find these tables and
drop them. There is a better solution -- to use CREATE TEMPORARY
TABLE. But to do this I would have to use PHP persistent data base
connections which, unlike the ordinary connections which my application
currently uses, drop and recreate connections when I move from one page
to another.
Changing means a significant code rewrite. I could, of course, encode
the creation date into the name of the table.
But I would like to know how to find the creation date of a table.
Thanks in advance
Mary Anderson
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-11-17 17:15:09 | Re: Systems view which gives creation date for a table? |
Previous Message | Wright, George | 2008-11-17 15:42:13 | pgpool |