Re: Tables creation date and time - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Tables creation date and time
Date
Msg-id CAFj8pRDK6RRSfYh=85a+w_TBj599h45DAtGDQF130GLWF6d3HQ@mail.gmail.com
Whole thread Raw
In response to Tables creation date and time  (Prashant Bharucha <prashantbharucha@yahoo.ca>)
List pgsql-general
Hello

2011/12/7 Prashant Bharucha <prashantbharucha@yahoo.ca>
Hello All

Could you please help me to find out of tables creation date and time in database ?

Thanks
P Bharucha

If you have a PostgreSQL 9.1, you can use a security hooks and write own custom extension, that will store a timestamp to somewhere. This task is possible - I did it, but I can't to publish this work. There are no other ways - you can find a some tips on net based on ctime of datafile - but these values should be invalid.

Regards

Pavel

pgsql-general by date:

Previous
From: "Marc Mamin"
Date:
Subject: Re: dblink performance
Next
From: Merlin Moncure
Date:
Subject: Re: dblink performance