From: David B <postgresql@thegatelys.com>
To: pgsql-sql@postgresql.org
Subject: How to figure out when was a table created
Date: Thu, 2 Oct 2003 16:01:16 -0700
Message-ID: <GOEGKICPFOPNLIEIHGFJEEJOCBAA.postgresql@thegatelys.com> (raw)
In-Reply-To: <GOEGKICPFOPNLIEIHGFJIEHJCBAA.postgresql@thegatelys.com>
Hi folks,
I posted this question a few days ago and got no response so I guess it
cannot be done (surprising!)
So that leaves me with my business problem.
We create a table for each days activity.
After N days (typically 7 days) we can drop the table.
The table name is not known so cannot force business to make tablename
something like mydata_MMDDYY
I'd like to be able to do something like:
SELECT tablename
FROM pg_???
WHERE to_char( ???, 'dd/mm/yy' ) = to_char( now() - interval '7 days',
'dd/mm/yy' )
Any suggestions?
--- Prior msg was:
Folks,
I have a list of tables for which I want to get the date they were
created...and if possible the date last updateded.
I suspect there is a pg_??? table that can answer this question but I don't
know what it is and I cannot find it mentioned in any docs.
Any suggestions...tia
-D
p.s. Love this forum!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: postgresql@thegatelys.com
Subject: Re: How to figure out when was a table created
In-Reply-To: <GOEGKICPFOPNLIEIHGFJEEJOCBAA.postgresql@thegatelys.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox