Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 3DBF56501D0 for ; Mon, 8 Dec 2008 17:16:18 -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 20084-10 for ; Mon, 8 Dec 2008 17:16:13 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.synechron.com (mail.synechron.com [74.205.14.240]) by mail.postgresql.org (Postfix) with ESMTP id 03EBC6501C8 for ; Mon, 8 Dec 2008 17:16:12 -0400 (AST) Received: from [10.31.9.119] [220.225.40.2] by mail.synechron.com with ESMTP (SMTPD-9.23) id AE9A03C0; Mon, 08 Dec 2008 16:16:10 -0500 Message-ID: <493CE50D.9030705@synechron.com> Date: Mon, 08 Dec 2008 14:42:45 +0530 From: AmitKumar Jain User-Agent: Thunderbird 2.0.0.18 (X11/20081105) MIME-Version: 1.0 To: "Milen A. Radev" CC: pgsql-admin@postgresql.org Subject: Re: How can we see details of function in psql prompt References: <493CDD91.40205@synechron.com> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=4.201 tagged_above=0 required=5 tests=DATE_IN_PAST_12_24=1.77, DNS_FROM_OPENWHOIS=2.431 X-Spam-Level: **** X-Archive-Number: 200812/64 X-Sequence-Number: 30897 Hi, \df will only give information aboutt its owner,argument,return type not its complete definition. I need to know the definition of function "record_part('test)" through psql prompt so is there any way to see it from psql prompt. Milen A. Radev wrote: > AmitKumar Jain написа: > >> Hi, >> >> 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) > > >