Is there a function to save schema history internally?

From: Patrick Dung <patrick_dkt(at)yahoo(dot)com(dot)hk>
To: Pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Is there a function to save schema history internally?
Date: 2014-08-29 18:23:26
Message-ID: 1409336606.13058.YahooMailNeo@web193505.mail.sg3.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Thanks and regards,
Patrick

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Emi Lu 2014-08-29 18:33:52 alter column to varchar without view drop/re-creation
Previous Message Rich Shepard 2014-08-29 17:15:09 Re: Single Table Report With Calculated Column