Thread: Is there a way to get an update date for objects in pg_class

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

Thanks

On Tuesday, July 15, 2014, Michael Paquier <michael.paquier@gmail.com> wrote:
> 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
>