Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: difference between pg_triggers and information_schema.triggers
Date
Msg-id CAKFQuwYYxi5BdgiKK5eOP6rb+bnL2EXFiaf2d7=qvborszJpzw@mail.gmail.com
Whole thread Raw
In response to difference between pg_triggers and information_schema.triggers  (aditya desai <admad123@gmail.com>)
Responses Re: difference between pg_triggers and information_schema.triggers
List pgsql-performance
Tree view
On Wednesday, August 11, 2021, aditya desai <admad123@gmail.com> 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 objects in PostgreSQL?(similar to all_objects in Oracle).


With pg_catalog tables.  But I’m not aware of anything that combines all object types into a single result.  Seems like an easy enough query to put together though.

David J.

pgsql-performance by date:

Previous
From: aditya desai
Date:
Subject: difference between pg_triggers and information_schema.triggers
Next
From: aditya desai
Date:
Subject: Re: difference between pg_triggers and information_schema.triggers