Objects / Procedure creation date or modified date

Started by akp geekover 16 years ago3 messagesgeneral
Jump to latest
#1akp 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

#2Brian Modra
epailty@googlemail.com
In reply to: akp geek (#1)
Re: Objects / Procedure creation date or modified date

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/

#3akp geek
akpgeek@gmail.com
In reply to: Brian Modra (#2)
Re: Objects / Procedure creation date or modified date

Thanks.. Will try that one

Regards

On Wed, Dec 16, 2009 at 9:29 AM, Brian Modra <epailty@googlemail.com> wrote:

Show quoted text

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/