Statistics on database structure changes

Поиск
Список
Период
Сортировка
Искать
От
Aleksey
Тема
Statistics on database structure changes
Дата
Msg-id
3FA0642B.6000504@ukr.net
Список
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.

В списке pgsql-general по дате отправления
От: Gaetano Mendola
Дата:
Сообщение: Re: Trigger delete
От: Allen Landsidel
Дата:
Сообщение: pg_ctl vs full restart
FAQ