August 11, 2021, aditya desai 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
On Wednesday, August 11, 2021, aditya desai 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 object
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