Re: Newbie question on how to check triggers created

Поиск
Список
Период
Сортировка
От Ed Loehr
Тема Re: Newbie question on how to check triggers created
Дата
Msg-id 3945008E.DB3577A6@austin.rr.com
обсуждение исходный текст
Ответ на Newbie question on how to check triggers created  (Chunky <so_excited@excite.com>)
Список pgsql-sql
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 по дате отправления:

Предыдущее
От: Chunky
Дата:
Сообщение: Newbie question on how to check triggers created
Следующее
От: Markus Wagner
Дата:
Сообщение: Re: postmaster: init.d/start