Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 3A1A364FC2A for ; Tue, 16 Dec 2008 10:50:14 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 36827-02 for ; Tue, 16 Dec 2008 10:50:08 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by mail.postgresql.org (Postfix) with ESMTP id A77566501BC for ; Tue, 16 Dec 2008 10:50:07 -0400 (AST) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Tue, 16 Dec 2008 08:50:04 -0600 Message-Id: <49476BB9.EE98.0025.0@wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0.3 Date: Tue, 16 Dec 2008 08:50:02 -0600 From: "Kevin Grittner" To: "Milen A. Radev" , "AmitKumar Jain" Cc: Subject: Re: How can we see details of function in psql prompt References: <493CDD91.40205@synechron.com> <493CE50D.9030705@synechron.com> In-Reply-To: <493CE50D.9030705@synechron.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-15 Content-Transfer-Encoding: 8bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200812/116 X-Sequence-Number: 30949 >>> AmitKumar Jain wrote: > Milen A. Radev wrote: >> AmitKumar Jain ******: >>> 1. Could any one please suggest me that how can I see the details of >>> function through psql prompt. >> \df+ >> >> (http://www.postgresql.org/docs/current/static/app-psql.html) > \df will only give information aboutt its owner,argument,return type not > its complete definition. Not \df alone, use \df+ "If the form \df+ is used, additional information about each function, including volatility, language, source code and description, is shown." From the URL cited by Milen. -Kevin