select from pg_trigger

From: "Garcia, Joshua" <Joshua(dot)Garcia(at)xerox(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: select from pg_trigger
Date: 2006-08-09 17:05:33
Message-ID: E00A3B716AD4C84FB97E42367015E8A00BFF3C@usa5911mf01.na.xerox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jim C. Nasby 2006-08-09 22:49:34 Re: query help
Previous Message Devrim GUNDUZ 2006-08-09 13:11:41 Re: pgadminIII in fedora core 4 : ident authentication