difference between pg_triggers and information_schema.triggers

Поиск
Список
Период
Сортировка
От aditya desai
Тема difference between pg_triggers and information_schema.triggers
Дата
Msg-id CAN0SRDHP=q-hPaw8A=xRwr=VmUstp++qAVpSNO=oWLwSGCRvnQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: difference between pg_triggers and information_schema.triggers  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-performance
Дерево обсуждения
Hi All,
What is the difference between pg_triggers and information_schema.triggers? I want to list all triggers in the database.

The count differs in both.

select count(1) from information_schema.triggers  -55
select count(1) from pg_trigger - 48

What is the best way to list all objects in PostgreSQL?(similar to all_objects in Oracle).


Regards,
Aditya.

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

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: Postgres using the wrong index index
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: difference between pg_triggers and information_schema.triggers