On Wednesday, August 11, 2021, aditya desai <admad123(at)gmail(dot)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.