On 2010-04-30, Didier Gasser-Morlay <didiergm(at)gmail(dot)com> wrote:
> --001636833a443f05eb0485777373
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi,
>
> Is there a way to determine the last modification date of the script of a
> function or trigger,
> Same question for relations and attributes ?
AFAIK no built-in way.
> My purpose would be to be able to list all DDL changes having occurred since
> a certain date, that would be very useful to me during application
> development with a fast evolving db schema.
if you do nightly --schema-only snapshots using pg_dump and store them over
each other in source code managemnt system (git, subversion, CVS, RCS,
codesafe - what-ever)
Then you can pull a diff from that and see the changed.