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

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