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
>