Re: databse version - Mailing list pgsql-general

From Adrian Klaver
Subject Re: databse version
Date
Msg-id 51B65298.7020005@gmail.com
Whole thread Raw
In response to databse version  (Philipp Kraus <philipp.kraus@flashpixx.de>)
List pgsql-general
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.klaver@gmail.com


pgsql-general by date:

Previous
From: Sajeev Mayandi
Date:
Subject: updatable view
Next
From: John R Pierce
Date:
Subject: Re: databse version