Re: How to get a list of procedures and triggers - Mailing list pgsql-general

From Jules Alberts
Subject Re: How to get a list of procedures and triggers
Date
Msg-id 200208280724.g7S7ONSM007293@artemis.cuci.nl
Whole thread Raw
In response to How to get a list of procedures and triggers  (pgsql-gen@basebeans.com (pgsql-gen Newsgroup (@Basebeans.com)))
List 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 by date:

Previous
From: pgsql-gen@basebeans.com (pgsql-gen Newsgroup (@Basebeans.com))
Date:
Subject: Data files became huge with no apparent reason
Next
From: Masse Jacques
Date:
Subject: Re: pl/pgsql create table