Search Postgresql Archives

Re: How could I find the last modified procedure in the database?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 11/16/11 8:00 AM, Dhimant Patel wrote:
I have postgres *(PostgreSQL) 9.0.3 running.*
I also created several procedures/functions and now I don't remember the last procedure I worked on! - I thought I could always get this from metadata.

Now I'm stuck - couldn't find this details anywhere in catalog tables!

Is there anyway I can get this information?

as far as I know, nothing like that is stored, unless you log DDL operations, and timestamp your logs, in which case it would be in the logfiles.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux