Re: Listing Triggers on a table.

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