Postgres Pro
Downloads
Home   >   mailing lists

Re: Is there a way to get an update date for objects in pg_class - Mailing list pgsql-general

From Michael Paquier
Subject Re: Is there a way to get an update date for objects in pg_class
Date
Msg-id CAB7nPqSWn=_cafamUGndzP4M7cWHZ9-Jc9e2efMqS9kAu88Uzw@mail.gmail.com
Whole thread Raw
In response to Is there a way to get an update date for objects in pg_class  (Néstor Boscán <nestorjb@gmail.com>)
Responses Re: Is there a way to get an update date for objects in pg_class
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Quering complete PLPGSQL code
Next
From: Marc Mamin
Date:
Subject: FW: operator is not unique: smallint[] @> smallint[] You might need to add explicit type casts (!)