Re: Objects / Procedure creation date or modified date

From: akp geek <akpgeek(at)gmail(dot)com>
To: Brian Modra <epailty(at)googlemail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Objects / Procedure creation date or modified date
Date: 2009-12-16 15:21:06
Message-ID: 2024a9fb0912160721l549940c6wc76c0d6033bbbe27@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks.. Will try that one

Regards

On Wed, Dec 16, 2009 at 9:29 AM, Brian Modra <epailty(at)googlemail(dot)com> wrote:

> 2009/12/16 akp geek <akpgeek(at)gmail(dot)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/
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2009-12-16 16:07:46 Re: How to remove non-UTF values from a table?
Previous Message Sam Mason 2009-12-16 15:01:41 Re: Need some advice on a difficult query