Thread: Newbie question on how to check triggers created

Hi folks,

Could someone please enlightenment me what command in psql i should use
to show the various triggers and rules that i have created?

Thanks alot in advance.

Regards
Damon

/*  Please be gentle with me, i'm a newbie.....  */

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