Thread: 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 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@operamail.com>
To: <pgsql-general@postgresql.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