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
Import Notes
Resolved by subject fallback