Postgres Pro
Downloads
Home   >   mailing lists

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

From Christoph Dalitz
Subject Re: How to get a list of procedures and triggers
Date
Msg-id 20020828102423.13d73c83.christoph.dalitz@hs-niederrhein.de
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
Tree view 
> 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

pgsql-general by date:

Previous
From: Barry Lind
Date:
Subject: Re: bytea, jdbc, i/o ...
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Data files became huge with no apparent reason