Can you add two columns to the table creation definition, one with a
default current timestamp, the second to be updated with current time in
an on update trigger. Then perhaps you could do something like
SELECT
min(new_insert_timestamp_column),
max(new_update_timestamp_column) FROM your_table
On Thu, Oct 02, 2003 at 16:01:16 -0700,
David B <[EMAIL PROTECTED]> wrote:
> 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
Well, in certain filesystems you can have the birth time
(like ufs2) stored in the inode struct.
So you find the file name in your $PGDATA/base directory
using the oid of your table (in pg_class),
and then you open that file with stat (2) or utimes (2) (or
from perl) to read creation data.
All t
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 b
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
