Re: Objects / Procedure creation date or modified date - Mailing list pgsql-general

From akp geek
Subject Re: Objects / Procedure creation date or modified date
Date
Msg-id 2024a9fb0912160721l549940c6wc76c0d6033bbbe27@mail.gmail.com
Whole thread Raw
In response to Re: Objects / Procedure creation date or modified date  (Brian Modra <epailty@googlemail.com>)
List pgsql-general
Thanks.. Will try that one

Regards

On Wed, Dec 16, 2009 at 9:29 AM, Brian Modra <epailty@googlemail.com> wrote:
2009/12/16 akp geek <akpgeek@gmail.com>:
> Dear all -
>                    How can we check when a procedure last modified or last
> DDL change happened to a table  in postgres? Which Pg_* do we need to query
> to get the details
> Regards

Maybe follow this line of thinking:
http://stackoverflow.com/questions/899203/how-do-i-find-the-last-time-that-a-postgresql-database-has-been-updated

--
Brian Modra   Land line: +27 23 5411 462
Mobile: +27 79 69 77 082
5 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
South Africa
http://www.zwartberg.com/

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: Need some advice on a difficult query
Next
From: Raymond O'Donnell
Date:
Subject: Re: How to remove non-UTF values from a table?