Thread: pg_proc - pg_triggers

On Fri, 7 Feb 2003, Yudha Setiawan wrote:

> As Developer we've been developing a simple tools
> for PostgreSQL under Windows, Just helping on Daily operation for our
> "IT-Operation Dept.". Someday I'll share that's tools for milist, i
> promise. But know we need to know how could we connecting two tables,
> between pg_proc and pg_trigger to findout my trigger's script. For now
> we just know the trigger's function without know which trigger is
> using it. Somebody can help us..??? Please.

Something like?

select * from pg_trigger, pg_proc where tgfoid = pg_proc.oid;