Postgres Pro
Downloads
Home   >   mailing lists

difference between pg_triggers and information_schema.triggers - Mailing list pgsql-performance

From aditya desai
Subject difference between pg_triggers and information_schema.triggers
Date
Msg-id CAN0SRDHP=q-hPaw8A=xRwr=VmUstp++qAVpSNO=oWLwSGCRvnQ@mail.gmail.com
Whole thread Raw
Responses Re: difference between pg_triggers and information_schema.triggers
List pgsql-performance
Tree view
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 by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: Postgres using the wrong index index
Next
From: "David G. Johnston"
Date:
Subject: Re: difference between pg_triggers and information_schema.triggers