Re: Object create date

1. not exactly what you were looking for, but i answer this partially by putting a commented-out CVS expansion tag
(e.g.$Id:) in the body of the function so that it gets into the catalog and can be searched:
 
 CREATE OR REPLACE FUNCTION foo () RETURNS void AS $BODY$ -- $Id: foo.sql,v 1.6 2008/12/23 00:06:52 gpavlov Exp $ BEGIN
...

and query it by something like this:
 select   routine_name,   substring(routine_definition from E'%#\042-- #\044Id: % Exp #\044#\042%' for '#') as cvs_id
frominformation_schema.routines ;
 

2. you can also make some inference about the relative timing of object creation based on the OIDs (query
pg_catalog.pg_procrather than information_schema.routines for proc OIDs).
 



> -----Original Message-----
> From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-
> owner@postgresql.org] On Behalf Of Fernando Hevia
> Sent: Monday, December 29, 2008 10:23 AM
> To: pgsql-sql@postgresql.org
> Subject: [SQL] Object create date
> 
> Hi list,
> 
> I'm having a hard time trying to find out if the latest patches have
> been applied to my application (uses lots of pgplsql functions).
> Does Postgres store creation date and/or modification date for tables,
> functions and other objects?
> It would help me a lot if I could query each object when it was
> created. Is this information available on 8.3? Where should I look?
> 
> Thanks,
> Fernando
>