On Wednesday, August 11, 2021, aditya desai <admad...@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.
