Обсуждение: Newbie question on how to check triggers created

Поиск
Список
Период
Сортировка

Newbie question on how to check triggers created

От
Chunky
Дата:
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.....  */



Re: Newbie question on how to check triggers created

От
Ed Loehr
Дата:
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