Return cluster-wide event triggers with event type, tags, function, owner, enabled status, and description.
read-onlyany connectionsweeps instancesweeps group
listEventTriggers()
Return cluster-wide event triggers with event type, tags, function, owner, enabled status, and description.
None of its own.
Also accepts connection, instance, group, described once under arguments every tool takes.
Keyed by event trigger name; each value is its event, function and enabled state. An absent extension or a missing grant is reported as {error, hint} in place of the map.
A physical replica is byte-identical here, so asking each member of a replication group adds nothing.
{
"jsonrpc": "2.0",
"id": 1,
"method": "tools/call",
"params": {
"name": "listEventTriggers",
"arguments": {}
}
}
{
"audit_ddl": {
"event": "ddl_command_end",
"function": "audit.log_ddl()",
"enabled": "origin",
"tags": null,
"owner": "postgres",
"description": "Records every DDL statement."
}
}
Invented values on a fictional shop database, shaped by and checked against this tool's output schema. Real output is returned as structuredContent to clients that negotiate MCP 2025-06-18 or later.
listRoles, listTablespaces, listLanguages, listAccessMethods, listCasts, listExtensions