Re: Retrieving comment of rules and triggers

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Retrieving comment of rules and triggers
Дата
Msg-id CAKFQuwa=3mpNkMfb+h-9krwYEjwZPNJ4cOHzX-kDi0+3xXuUtw@mail.gmail.com
обсуждение исходный текст
Ответ на Retrieving comment of rules and triggers  (Alex Magnum <magnum11200@gmail.com>)
Ответы Re: Retrieving comment of rules and triggers  (Melvin Davidson <melvin6925@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Thu, Jun 9, 2016 at 4:45 PM, Alex Magnum <magnum11200@gmail.com> wrote:
Hi, is there a way to retrieve the comment of rules and triggers. I worked it out on functions, tables, views but am kind of stuck with rules and triggers.


​Table ​9-63. Comment Information Functions

obj_description(object_oid, catalog_name)

Catalog Names:

pg_trigger
pg_rules

The source catalog for the data is:

pg_description

I'm suspect of your existing solution given that this is supposed to be a universal interface for comment data...

David J.

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

Предыдущее
От: Alex Magnum
Дата:
Сообщение: Retrieving comment of rules and triggers
Следующее
От: Melvin Davidson
Дата:
Сообщение: Re: Retrieving comment of rules and triggers