Thread: How to get a list of procedures and triggers
How to get a list of procedures and triggers
From
pgsql-gen@basebeans.com (pgsql-gen Newsgroup (@Basebeans.com))
Date:
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