Thread: Getting trigger names on a table

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

On Thu, May 31, 2001 at 11:56:18AM -0400, Andrew Sullivan wrote:

> I'd like to get back the names of triggers defined on a table.

I knew as soon as I sent mail to the list, I'd find it (much to my
embarrassment).  For the sake of the archives, a nice example is at

    http://www.archonet.com/pgdocs/chap-systbl.html#VIEW-TRIGGERS

(although the URL might change, according to the front page.  Start
at http://www.archonet.com/pgdocs/pgnotes.html.)

A