Re: Listing Triggers - Mailing list pgsql-admin

From Tom Lane
Subject Re: Listing Triggers
Date
Msg-id 23597.1012406267@sss.pgh.pa.us
Whole thread Raw
In response to Listing Triggers  (Brian McCane <bmccane@mccons.net>)
List pgsql-admin
Brian McCane <bmccane@mccons.net> writes:
> How can I list the triggers on a specific table?

select * from pg_trigger where tgrelid =
(select oid from pg_class where relname = 'foo');

This table is documented now in the 7.2 documentation; see
http://developer.postgresql.org/docs/postgres/catalog-pg-trigger.html

            regards, tom lane

pgsql-admin by date:

Previous
From: "Eduardo Caillava"
Date:
Subject: Re: INSERT performace.
Next
From: "Arguile"
Date:
Subject: Re: Listing Triggers