From: | "Dan Wilson" <phpPgAdmin(at)acucore(dot)com> |
---|---|
To: | "Paul" <paul(at)operamail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Listing Triggers on a table. |
Date: | 2000-11-27 07:40:19 |
Message-ID: | 00a701c05845$4ba47270$078353d8@danwilson |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
From the newly added phpPgAdmin source code:
SELECT tgname AS trigger_name, pt.typname as result, pc.relname as
table_name
FROM pg_trigger ptr, pg_type pt, pg_class pc
WHERE ptr.tgtype = pt.oid
AND ptr.tgrelid = pc.oid
AND tgname !~ 'pg_.*'
AND pc.relname = '[insert table name]'
ORDER BY tgname
Get the latest phpPgAdmin at http://www.greatbridge.org/project/phppgadmin
-Dan Wilson
----- Original Message -----
From: "Paul" <paul(at)operamail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Sunday, November 26, 2000 8:21 PM
Subject: [GENERAL] Listing Triggers on a table.
> How do I go about finding out the names of triggers attached to a table?
> Currently I'm doing :
> pg_dump <dbname> | grep TRIGGER | grep <tablename>
> from the shell command line. Is there a quicker way of doing it in psql?
>
> Paul
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Chmara | 2000-11-27 07:49:04 | Re: Postgres and AOLServer |
Previous Message | Bruce Momjian | 2000-11-27 06:17:03 | Upcoming speeches |