Re: How to get a list of procedures and triggers

Поиск
Список
Период
Сортировка
От Jules Alberts
Тема Re: How to get a list of procedures and triggers
Дата
Msg-id 200208280724.g7S7ONSM007293@artemis.cuci.nl
обсуждение исходный текст
Ответ на How to get a list of procedures and triggers  (pgsql-gen@basebeans.com (pgsql-gen Newsgroup (@Basebeans.com)))
Список pgsql-general
Дерево обсуждения 
On 27 Aug 2002 at 23:40, pgsql-gen Newsgroup (@Basebea wrote:
> Subject: [GENERAL] How to get a list of procedures and triggers
> From: Jean-Christian Imbeault <jc@mega-bucks.co.jp>
>  ===
> Sorry for the simply question but I just can't seem to find the answer
> in the docs.
>
> How can I get a listing of all the stored procedures and triggers for my
>
>    database?

In pgsql have a look at \df, this might do what you want. There's a
catch though: functions that return OPAQUE aren't listed.

--
Jules Alberts.

В списке pgsql-general по дате отправления:

Предыдущее
От: pgsql-gen@basebeans.com (pgsql-gen Newsgroup (@Basebeans.com))
Дата:
Сообщение: Data files became huge with no apparent reason
Следующее
От: Masse Jacques
Дата:
Сообщение: Re: pl/pgsql create table