Postgres Pro
Downloads
Home   >   mailing lists

Re: Newbie question on how to check triggers created - Mailing list pgsql-sql

From Ed Loehr
Subject Re: Newbie question on how to check triggers created
Date
Msg-id 3945008E.DB3577A6@austin.rr.com
Whole thread Raw
In response to Newbie question on how to check triggers created  (Chunky <so_excited@excite.com>)
List pgsql-sql
Tree view 
Chunky wrote:
> 
> Could someone please enlightenment me what command in psql i should use
> to show the various triggers and rules that i have created?

These might work...

select tgname from pg_trigger
select rulename from pg_rewrite

Regards,
Ed Loehr

pgsql-sql by date:

Previous
From: Chunky
Date:
Subject: Newbie question on how to check triggers created
Next
From: Markus Wagner
Date:
Subject: Re: postmaster: init.d/start