Re: difference between pg_triggers and information_schema.triggers

2021-08-11 Thread aditya desai
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

Re: difference between pg_triggers and information_schema.triggers

2021-08-11 Thread David G. Johnston
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

difference between pg_triggers and information_schema.triggers

2021-08-11 Thread aditya desai
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