Skip site navigation (1) Skip section navigation (2)

list user created triggers

From: "sathiya psql" <sathiya(dot)psql(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: list user created triggers
Date: 2008-03-11 13:38:33
Message-ID: f966c2ee0803110638i57c94c4k533a635bcf9e82fb@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
how to find trigger names in my database ?

using psql 7.4

the following query shows system triggers, i want only to list the
triggers created by me

select relname, tgname, tgtype, proname, prosrc, tgisconstraint,
tgconstrname, tgconstrrelid, tgdeferrable, tginitdeferred, tgnargs,
tgattr, tgargs from (pg_trigger join pg_class on tgrelid=pg_class.oid)
join pg_proc on (tgfoid=pg_proc.oid);

pgsql-performance by date

Next:From: Dave CramerDate: 2008-03-11 13:46:08
Subject: Re: how many index can have????
Previous:From: Bill MoranDate: 2008-03-11 13:35:37
Subject: Re: count * performance issue

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group