Re: How to get a list of procedures and triggers

From: Christoph Dalitz <christoph(dot)dalitz(at)hs-niederrhein(dot)de>
To: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to get a list of procedures and triggers
Date: 2002-08-28 08:24:23
Message-ID: 20020828102423.13d73c83.christoph.dalitz@hs-niederrhein.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2002-08-28 09:12:58 Re: Data files became huge with no apparent reason
Previous Message Barry Lind 2002-08-28 08:16:30 Re: bytea, jdbc, i/o ...