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.
