Re: Procedures, rules & UDF's....

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Greg Patnude <gpatnude(at)hotmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Procedures, rules & UDF's....
Date: 2005-03-02 08:25:57
Message-ID: 20050302082557.GD47871@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Feb 28, 2005 at 02:22:59PM -0800, Greg Patnude wrote:

> Is there a quick and dirty SQL query where I can locate the rules,
> procudures and user-defined functions in the system catalogs ???
>
> there ain't a ton of documentation on the pg_catalog tables & view....

Have you seen the "System Catalogs" chapter in the documentation?

http://www.postgresql.org/docs/8.0/interactive/catalogs.html

Are you looking for something else? If so, could you be more
specific?

Running "psql -E" and looking at the output of \d commands can be
instructive.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message William Shatner 2005-03-02 09:18:58 Automatic database backup on Windows Machine
Previous Message Michael Fuhr 2005-03-02 08:08:48 Re: Scheduling/Automated Jobs in Postgre