Home > mailing lists

select from pg_trigger - Mailing list pgsql-novice

From	Garcia, Joshua
Subject	select from pg_trigger
Date	August 9, 2006 17:29:56
Msg-id	E00A3B716AD4C84FB97E42367015E8A00BFF3C@usa5911mf01.na.xerox.net Whole thread Raw
Responses	Re: select from pg_trigger ("Jim C. Nasby" <jnasby@pervasive.com>)
List	pgsql-novice

Tree view

Is there a way for me to SELECT from pg_trigger the names of all the functions that I’ve added to my database, plus the names of the tables they are triggered on? Ultimately, I want to create a list I can use to drop all triggers.

Thanks in advance,

Josh

pgsql-novice by date:

From: Devrim GUNDUZ
Date: 09 August 2006, 13:11:37
Subject: Re: pgadminIII in fedora core 4 : ident authentication

From: "Jim C. Nasby"
Date: 09 August 2006, 22:49:46
Subject: Re: query help

select from pg_trigger - Mailing list pgsql-novice

Previous

Next