Re: difference between pg_triggers and information_schema.triggers

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: difference between pg_triggers and information_schema.triggers
Дата
Msg-id CAKFQuwYYxi5BdgiKK5eOP6rb+bnL2EXFiaf2d7=qvborszJpzw@mail.gmail.com
обсуждение исходный текст
Ответ на difference between pg_triggers and information_schema.triggers  (aditya desai <admad123@gmail.com>)
Ответы Re: difference between pg_triggers and information_schema.triggers  (aditya desai <admad123@gmail.com>)
Список pgsql-performance
Дерево обсуждения
On Wednesday, August 11, 2021, aditya desai <admad123@gmail.com> wrote:
Hi All,
What is the difference between pg_triggers and information_schema.triggers? I want to list all triggers in the database.

Read the docs for information_schema.triggers.
 
What is the best way to list all objects in PostgreSQL?(similar to all_objects in Oracle).


With pg_catalog tables.  But I’m not aware of anything that combines all object types into a single result.  Seems like an easy enough query to put together though.

David J.

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

Предыдущее
От: aditya desai
Дата:
Сообщение: difference between pg_triggers and information_schema.triggers
Следующее
От: aditya desai
Дата:
Сообщение: Re: difference between pg_triggers and information_schema.triggers