Re: How can we see details of function in psql prompt

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Milen A(dot) Radev" <milen(at)radev(dot)net>, "AmitKumar Jain" <amitjain(at)synechron(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: How can we see details of function in psql prompt
Date: 2008-12-16 14:50:02
Message-ID: 49476BB9.EE98.0025.0@wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

>>> AmitKumar Jain <amitjain(at)synechron(dot)com> 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Rafael Domiciano 2008-12-16 17:14:55 Re: Vacuum Problems
Previous Message Alvaro Herrera 2008-12-16 14:43:27 Re: [ADMIN] shared_buffers and shmmax