Re: Tables creation date and time

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Prashant Bharucha <prashantbharucha(at)yahoo(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Tables creation date and time
Date: 2011-12-07 21:44:26
Message-ID: CAFj8pRDK6RRSfYh=85a+w_TBj599h45DAtGDQF130GLWF6d3HQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello

2011/12/7 Prashant Bharucha <prashantbharucha(at)yahoo(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2011-12-07 21:49:24 Re: dblink performance
Previous Message Marc Mamin 2011-12-07 21:37:40 Re: dblink performance