Is there a way to get an update date for objects in pg_class
Hi
I want to know if there is a way to get the last modified date of the
objects structure like tables, views or sequences.
Regards,
Néstor
On Tue, Jul 15, 2014 at 9:42 AM, Néstor Boscán <nestorjb@gmail.com> wrote:
I want to know if there is a way to get the last modified date of the
objects structure like tables, views or sequences.
Not directly within the server if this is what you mean as catalog
tables do not track timestamps when changes to an object occurred. An
alternative would be to have server logs verbose enough to report this
information.
Regards,
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Thanks
On Tuesday, July 15, 2014, Michael Paquier <michael.paquier@gmail.com>
wrote:
Show quoted text
On Tue, Jul 15, 2014 at 9:42 AM, Néstor Boscán <nestorjb@gmail.com> wrote:
I want to know if there is a way to get the last modified date of the
objects structure like tables, views or sequences.Not directly within the server if this is what you mean as catalog
tables do not track timestamps when changes to an object occurred. An
alternative would be to have server logs verbose enough to report this
information.
Regards,
--
Michael