Re: Listing Triggers

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Brian McCane <bmccane(at)mccons(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Listing Triggers
Date: 2002-01-30 15:57:47
Message-ID: 23597.1012406267@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

Brian McCane <bmccane(at)mccons(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Arguile 2002-01-30 16:30:25 Re: Listing Triggers
Previous Message Eduardo Caillava 2002-01-30 15:10:17 Re: INSERT performace.

Browse pgsql-sql by date

  From Date Subject
Next Message Arguile 2002-01-30 16:30:25 Re: Listing Triggers
Previous Message Chris Ruprecht 2002-01-30 15:10:57 Re: psql and macOSX with 7.2b5