| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | reiner peterke <zedaardv(at)drizzle(dot)com> |
| Cc: | Nik Tek <niktek2005(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: How to find table creation time |
| Date: | 2014-04-05 15:44:57 |
| Message-ID: | 1396712697.2641.1.camel@localhost.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Sat, 2014-04-05 at 08:26 +0200, reiner peterke wrote:
> Hi,
>
> Unfortunately not. This is a feature that is lacking in postgres.
>
> One could always look at the file node times, but this is unreliable too, as an operation like a vacuum full will create a new file node.
> I haven't found a good way to work around this either.
>
I don't think it would be quite difficult to create an extension that
uses a hook to record the timestamp when a user creates a table.
Something like what was done around CREATE EXTENSION to allow adding
some extensions but not all, according to a white list.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Murthy Nunna | 2014-04-06 21:25:51 | Cascade Standby - [FATAL: the database system is starting up] |
| Previous Message | reiner peterke | 2014-04-05 06:26:47 | Re: How to find table creation time |