X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id F39B2564C6 for ; Mon, 28 Feb 2005 22:37:42 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 78376-04 for ; Mon, 28 Feb 2005 22:37:34 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 68D81564B4 for ; Mon, 28 Feb 2005 22:37:34 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j1SMbY6K079850 for ; Mon, 28 Feb 2005 22:37:34 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j1SMM0Wm076481 for pgsql-admin@postgresql.org; Mon, 28 Feb 2005 22:22:00 GMT (envelope-from news) From: "Greg Patnude" X-Newsgroups: pgsql.admin Subject: Procedures, rules & UDF's.... Date: Mon, 28 Feb 2005 14:22:59 -0800 Organization: dataMosaics.com Lines: 8 Message-ID: Reply-To: "Greg Patnude" X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Original To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200503/10 X-Sequence-Number: 16508 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.... TIA....