Обсуждение: Objects / Procedure creation date or modified date
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
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/
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>:Maybe follow this line of thinking:> 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
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/