Hi Adrian, Thanks for the info.
Thanks and regards, Patrick On Saturday, August 30, 2014 5:28 AM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: On 08/29/2014 11:23 AM, Patrick Dung wrote: > Hello Postgresql users, > > Is there a function to save schema history internally? > By keeping the schema history inside the DB, we can keep track of what > and when is changed in the schema. > > While searching google. It seems it is a limitation with the audit trigger: > https://wiki.postgresql.org/wiki/Audit_trigger#Limitation:_Cannot_audit_DDL Well going forward, 9.4+, there are EVENT TRIGGERS http://www.postgresql.org/docs/9.4/static/event-triggers.html For a recent thread on what is possible or not see: http://www.postgresql.org/message-id/20ee50f73664e744af948f0106fe6dfa585a7...@seambx01.sea.corp.int.untd.com > > Thanks and regards, > Patrick -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general