Обсуждение: Listing viewing triggers

Greetings to the list from DownUnder!

I have created a number of triggers and do not remember exactly what I
called them. How do I list the triggers (to refint.c) I have created and
which tables they reference etc.??


---------------------------------------------------------
ANDREW GIBSON (Director - Information Services)
Cannon Hill Anglican College  http://www.chac.qld.edu.au/
PO Box 3366, Tingalpa DC, Q 4173, AUS
Ph: +61 7 3896 0444, Fax: +61 7 3896 0448

select * from pg_trigger;

Andrew Gibson wrote:

> Greetings to the list from DownUnder!
>
> I have created a number of triggers and do not remember exactly what I
> called them. How do I list the triggers (to refint.c) I have created and
> which tables they reference etc.??
>
> ---------------------------------------------------------
> ANDREW GIBSON (Director - Information Services)
> Cannon Hill Anglican College  http://www.chac.qld.edu.au/
> PO Box 3366, Tingalpa DC, Q 4173, AUS
> Ph: +61 7 3896 0444, Fax: +61 7 3896 0448