Getting trigger names on a table

Started by Andrew Sullivanalmost 25 years ago2 messagesgeneral
Jump to latest
#1Andrew Sullivan
andrew@libertyrms.com

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

#2Andrew Sullivan
andrew@libertyrms.com
In reply to: Andrew Sullivan (#1)
Re: Getting trigger names on a table

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