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

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Néstor Boscán <nestorjb(at)gmail(dot)com>
Cc: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: Is there a way to get an update date for objects in pg_class
Date: 2014-07-15 04:58:45
Message-ID: CAB7nPqSWn=_cafamUGndzP4M7cWHZ9-Jc9e2efMqS9kAu88Uzw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jul 15, 2014 at 9:42 AM, Néstor Boscán <nestorjb(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc Mamin 2014-07-15 11:26:47 FW: operator is not unique: smallint[] @> smallint[] You might need to add explicit type casts (!)
Previous Message Adrian Klaver 2014-07-15 03:10:56 Re: Quering complete PLPGSQL code