Re: How to get a list of procedures and triggers

From: "Jules Alberts" <jules(dot)alberts(at)arbodienst-limburg(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to get a list of procedures and triggers
Date: 2002-08-28 07:06:19
Message-ID: 200208280724.g7S7ONSM007293@artemis.cuci.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)mega-bucks(dot)co(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Masse Jacques 2002-08-28 08:13:04 Re: pl/pgsql create table
Previous Message pgsql-gen Newsgroup @Basebeans.com 2002-08-28 06:55:03 Data files became huge with no apparent reason