Seems like multiple entries in information_schema.triggers for
INSERT/UPDATE/DELETE. Understood thanks.
postgres=# select tgname,tgtype from pg_trigger;
tgname | tgtype
+
insert_empployee | 31
insert_empployee_1 | 31
(2 rows)
postgres=# selec
On Wednesday, August 11, 2021, aditya desai 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?(s
