PostgreSQL - Display internally generated constraint triggers

In PostgreSQL, it could be greate to see internally generated triggers.

For exemple, Foreign Key uses internally generated trigger.

Those can be find in the view : pg_trigger which have a column tgisinternal to check if the trigger is internal.

When you use ALTER TABLE DISABLE TRIGGER ALL, it disable those trigger (but ALTER TABLE DISABLE TRIGGER USER not). Seeing those triggers can alert on what you might do by disabling all triggers.