Обсуждение: How to get a list of procedures and triggers

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?

Jc


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

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.

> How can I get a listing of all the stored procedures and triggers for my
> database?
>
Have a look at the tables pg_proc and pg_trigger from the system catalog
(aka "data dictionary").

It is documented in the "Developer's Guide", chapter 3 "System Catalog".

Christoph Dalitz