John Mitchell wrote:
I am trying to store schema definitions in version-control which I can do by
saving the definition and then importing into svn, but I would like it
to be automatic , so that when an update occurs to a table or view within
postgres then that table or view is flagged within svn. This would be
similar to what I currently do with source code that I have for a web app
within eclipse.
Ah! I'm not aware of any such system.
You could write a small cron-script that dumped the schema once every 5
minutes so it could be picked up by svn.
I think most people have a separate collection of schema-creation/update
scripts that they keep under version control. All changes are then
through running these.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
