DELETE FROM pg_description WHERE ...

Поиск
Список
Период
Сортировка
От Erwin Brandstetter
Тема DELETE FROM pg_description WHERE ...
Дата
Msg-id da0a7ec9-70de-4017-a514-8d62596f13f7@x10g2000vbn.googlegroups.com
обсуждение исходный текст
Ответы Re: DELETE FROM pg_description WHERE ...
Re: DELETE FROM pg_description WHERE ...
Список pgsql-admin
Hi!

It is generally not advisable to write to system catalogs directly ...

However, I have a database with dozens of schemas and hundreds of
tables. There is a bunch of useless comments on columns I want to get
rid of, scattered all across the db. The fastest & easiest way would
be:

DELETE FROM pg_description WHERE description = 'My very special
totally useless comment.';

AFAICS, there are no side-effects. Are there any?


TIA!
Erwin Brandstetter

В списке pgsql-admin по дате отправления:

Предыдущее
От: Cédric Villemain
Дата:
Сообщение: Re: Reseting statistics, cluster wide
Следующее
От: Steve Crawford
Дата:
Сообщение: Re: unix timestamp