Re: Show triggers in psql?

You can get a list of all triggers in the system
as
select * from pg_trigger;

You can get the source for a PL function a trigger
calls with:
select prosrc from pg_trigger,pg_proc where
 pg_proc.oid=pg_trigger.tgfoid
 and pg_trigger.tgname = '<name>'

[Note, in the case of C functions, I think this
returns the name of the function.]


Stephan Szabo
sszabo@bigpanda.com

On Thu, 14 Sep 2000, Bryan Field-Elliot wrote:

> Forgive me if I am missing the obvious, but can someone please tell me how
> to show a list of triggers, or the code in a specific trigger, via the pgsql
> utility?
>
> Thank you,
> Bryan
>