Re: How to find table creation time

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux