Re: pg_proc - pg_triggers - Mailing list pgsql-admin

From Stephan Szabo
Subject Re: pg_proc - pg_triggers
Date
Msg-id 20030207064857.B55352-100000@megazone23.bigpanda.com
Whole thread Raw
In response to pg_proc - pg_triggers  ("Yudha Setiawan" <yudha@BonBon.net>)
List pgsql-admin
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;



pgsql-admin by date:

Previous
From: Rajesh Kumar Mallah
Date:
Subject: Re: Vacuum full hang => strace
Next
From: Palle Girgensohn
Date:
Subject: incremental backup of postgres database?