X-Original-To: pgsql-chat-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 60E4B3A47A0 for ; Thu, 4 Nov 2004 03:47:01 +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 84405-04 for ; Thu, 4 Nov 2004 03:46:50 +0000 (GMT) Received: from lakermmtao06.cox.net (lakermmtao06.cox.net [68.230.240.33]) by svr1.postgresql.org (Postfix) with ESMTP id 9A50F3A479A for ; Thu, 4 Nov 2004 03:46:53 +0000 (GMT) Received: from [192.168.0.8] (really [24.136.36.194]) by lakermmtao06.cox.net (InterMail vM.6.01.04.00 201-2131-117-20041022) with ESMTP id <20041104034652.CUQK329.lakermmtao06.cox.net@[192.168.0.8]>; Wed, 3 Nov 2004 22:46:52 -0500 From: Robert Treat To: Norman Ross Subject: Re: How do I "describe" a stored procedure? Date: Wed, 3 Nov 2004 22:45:41 -0500 User-Agent: KMail/1.6.2 Cc: pgsql-chat@postgresql.org References: <20041101175212.49592.qmail@web50407.mail.yahoo.com> In-Reply-To: <20041101175212.49592.qmail@web50407.mail.yahoo.com> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Message-Id: <200411032245.43251.xzilla@users.sourceforge.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/2 X-Sequence-Number: 20 On Monday 01 November 2004 12:52, Norman Ross wrote: > After I create a stored procedure, how can I go back to see the definition > of THAT stored procedure? > inside psql you can use: \df+ function_name btw, no one uses pgsql-chat, try switching to pgsql-general or pgsql-novice instead. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL