difference between pg_triggers and information_schema.triggers

From: aditya desai <admad123(at)gmail(dot)com>
To: Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: difference between pg_triggers and information_schema.triggers
Date: 2021-08-11 18:28:22
Message-ID: CAN0SRDHP=q-hPaw8A=xRwr=VmUstp++qAVpSNO=oWLwSGCRvnQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message David G. Johnston 2021-08-11 18:37:27 Re: difference between pg_triggers and information_schema.triggers
Previous Message Justin Pryzby 2021-08-11 12:38:56 Re: Postgres using the wrong index index