X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1AC07D924E for ; Fri, 23 Sep 2005 13:15:34 -0300 (ADT) 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 04738-09 for ; Fri, 23 Sep 2005 16:15:30 +0000 (GMT) Received: from tamar.dmr.co.uk (tamar.dmr.co.uk [195.112.52.166]) by svr1.postgresql.org (Postfix) with ESMTP id 837D3D9227 for ; Fri, 23 Sep 2005 13:15:29 -0300 (ADT) Received: from HFPORT.dmr.co.uk (pennsoft.gotadsl.co.uk [81.6.232.68]) by tamar.dmr.co.uk (8.12.11/8.12.11) with ESMTP id j8NGFSLO021392; Fri, 23 Sep 2005 17:15:28 +0100 Message-Id: <5.1.0.14.0.20050923171510.0205bc40@mailserver.dmr.co.uk> X-Sender: hf1@mailserver.dmr.co.uk X-Mailer: QUALCOMM Windows Eudora Version 5.1 Date: Fri, 23 Sep 2005 17:18:22 +0100 To: Tom Lane From: Hilary Forbes Subject: Re: Where are user defined functions stored? Cc: Pgsql-sql@postgresql.org In-Reply-To: <3796.1127486414@sss.pgh.pa.us> References: <5.1.0.14.0.20050923150802.03484f38@mailserver.dmr.co.uk> <5.1.0.14.0.20050923150802.03484f38@mailserver.dmr.co.uk> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 required=5 tests=[FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200509/230 X-Sequence-Number: 22777 Tom Many thanks. Suppose I now want to know if there are any user defined functions set up in my database? I was rather hoping I could do something simple like \df to get a list of **user** defined functions rather as \dt gives me a list of my tables and not the complete list of all the system tables as well. Is there a way of achieving this? Hilary At 10:40 23/09/2005 -0400, you wrote: >Hilary Forbes writes: >> How can I easily get to see the definition of a user defined function >> please? > >Look in pg_proc. > > regards, tom lane > >---------------------------(end of broadcast)--------------------------- >TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq Hilary Forbes The DMR Information and Technology Group (www.dmr.co.uk) Direct tel 01689 889950 Fax 01689 860330 DMR is a UK registered trade mark of DMR Limited **********************************************************