Re: Last modification date for Triggers, functions, tables ....

On 2010-04-30, Didier Gasser-Morlay <didiergm@gmail.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.