By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,372 Members | 1,906 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,372 IT Pros & Developers. It's quick & easy.

Statistics on database structure changes

P: n/a
Hello,

I need to collect some information on changes in database structure for
further analysis. I'm interested in the following information:
- new and dropped tables and views;
- new and dropped table columns;
- new and dropped primary and foreign keys;
- timestamp of such a change;
- affected table and probably columns for every change.

Are there any other "native" ways to do this (to export certain
successfully(!) finished queries) without parsing PostgreSQL's log
on-the-fly or modification of the backend source?

Thank you.
Sincerely yours,
Aleksey.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.