Re: databse version

On 06/10/2013 12:52 AM, Philipp Kraus wrote:
> Hello,
>
> I'm creating a database and I have got a table with a "version" field.
> Can I update on structure changes (DDL) like create / update table
> increment this field automatically?
> I would like to create a versionizing for my database which counts the
> changes.
> IMHO I need a trigger, which is run if a DDL statement is fired on the
> database

In the current beta 9.3 there are event triggers that would seem to be
what you are looking for:

http://www.postgresql.org/docs/9.3/static/event-triggers.html

>
> Thanks
>
> Phil
>
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com