SHOW TRIGGERS

The SHOW TRIGGERS statement lists the triggers defined on a table.

Required privileges

The user must have any privilege on the target table.

Parameter	Description
`table_name`	The name of the table for which to list triggers.

Field	Description
`trigger_name`	The name of the trigger.
`enabled`	Whether the trigger is enabled.

Create a sample table and trigger:

CREATE TABLE users (id INT PRIMARY KEY, name STRING);

CREATE FUNCTION update_timestamp()
RETURNS TRIGGER AS $$
BEGIN
  RAISE NOTICE 'Current timestamp: %', now();
  RETURN NEW;
END;
$$ LANGUAGE PLpgSQL;

CREATE TRIGGER log_update_timestamp
AFTER UPDATE ON users
FOR EACH ROW
EXECUTE FUNCTION update_timestamp();

List the triggers on the table:

SHOW TRIGGERS FROM users;

      trigger_name     | enabled
-----------------------+----------
  log_update_timestamp |    t
(1 row)