Getting trigger names on a table

From: Andrew Sullivan <andrew(at)libertyrms(dot)com>
To: PostgreSQL general list <pgsql-general(at)postgresql(dot)org>
Subject: Getting trigger names on a table
Date: 2001-05-31 15:56:18
Message-ID: 20010531115618.E28332@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm sure there's a reference to this somewhere in the Fine Material,
but I've had no luck locating it.

I'd like to get back the names of triggers defined on a table. I've
looked at the pg_trigger catalogue, but I can't see how that could
give me the info I need. I know that pg_class can tell me the
_number_ of triggers on the table, but it doesn't seem to tell me
what they are. Can anyone provide me with a hint or pointer to the
relevant bit of the docs?

Thanks,
Andrew

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Seth 2001-05-31 16:26:43 outer joins take forever
Previous Message Renaud Thonnart 2001-05-31 15:42:38 Re: table inheritance