pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHow can we see details of function in psql prompt
5+ messages / 3 participants
[nested] [flat]
* How can we see details of function in psql prompt
@ 2008-12-08 08:40 AmitKumar Jain <amitjain@synechron.com>
2008-12-08 08:49 ` Re: How can we see details of function in psql prompt AmitKumar Jain <amitjain@synechron.com>
2008-12-08 21:06 ` Re: How can we see details of function in psql prompt Milen A. Radev <milen@radev.net>
0 siblings, 2 replies; 5+ messages in thread
From: AmitKumar Jain @ 2008-12-08 08:40 UTC (permalink / raw)
To: pgsql-admin
Hi,
1. Could any one please suggest me that how can I see the details of
function through psql prompt.
2. We can use cactii as a monitoring tool for mysql what is the similar
monitoring tool except nagios for postgreSQL
Thankx in Advance
Amit
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: How can we see details of function in psql prompt
2008-12-08 08:40 How can we see details of function in psql prompt AmitKumar Jain <amitjain@synechron.com>
@ 2008-12-08 08:49 ` AmitKumar Jain <amitjain@synechron.com>
1 sibling, 0 replies; 5+ messages in thread
From: AmitKumar Jain @ 2008-12-08 08:49 UTC (permalink / raw)
To: Hoover, Jeffrey <jhoover@jcvi.org>; +Cc: pgsql-admin
admin=# \x
Expanded display is on.
admin=# select * from pg_proc where proname = 'abstime';
-[ RECORD 1 ]--+--------------------
proname | abstime
pronamespace | 11
proowner | 10
prolang | 12
procost | 1
prorows | 0
proisagg | f
prosecdef | f
its only showing the information about the function not what exactly
written insdie the function. I need to know the definition of function
through psql prompt.
Hoover, Jeffrey wrote:
> 1. assuming a function named "appendrows"
>
> select * from pg_proc where proname='appendrows';
>
>
> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of AmitKumar Jain
> Sent: Monday, December 08, 2008 3:41 AM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] How can we see details of function in psql prompt
>
> Hi,
>
> 1. Could any one please suggest me that how can I see the details of
> function through psql prompt.
> 2. We can use cactii as a monitoring tool for mysql what is the similar
> monitoring tool except nagios for postgreSQL
>
>
> Thankx in Advance
> Amit
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: How can we see details of function in psql prompt
2008-12-08 08:40 How can we see details of function in psql prompt AmitKumar Jain <amitjain@synechron.com>
@ 2008-12-08 21:06 ` Milen A. Radev <milen@radev.net>
2008-12-08 09:12 ` Re: How can we see details of function in psql prompt AmitKumar Jain <amitjain@synechron.com>
1 sibling, 1 reply; 5+ messages in thread
From: Milen A. Radev @ 2008-12-08 21:06 UTC (permalink / raw)
To: pgsql-admin
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)
--
Milen A. Radev
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: How can we see details of function in psql prompt
2008-12-08 08:40 How can we see details of function in psql prompt AmitKumar Jain <amitjain@synechron.com>
2008-12-08 21:06 ` Re: How can we see details of function in psql prompt Milen A. Radev <milen@radev.net>
@ 2008-12-08 09:12 ` AmitKumar Jain <amitjain@synechron.com>
2008-12-16 14:50 ` Re: How can we see details of function in psql prompt Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 1 reply; 5+ messages in thread
From: AmitKumar Jain @ 2008-12-08 09:12 UTC (permalink / raw)
To: Milen A. Radev <milen@radev.net>; +Cc: pgsql-admin
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)
>
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: How can we see details of function in psql prompt
2008-12-08 08:40 How can we see details of function in psql prompt AmitKumar Jain <amitjain@synechron.com>
2008-12-08 21:06 ` Re: How can we see details of function in psql prompt Milen A. Radev <milen@radev.net>
2008-12-08 09:12 ` Re: How can we see details of function in psql prompt AmitKumar Jain <amitjain@synechron.com>
@ 2008-12-16 14:50 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 0 replies; 5+ messages in thread
From: Kevin Grittner @ 2008-12-16 14:50 UTC (permalink / raw)
To: Milen A. Radev <milen@radev.net>; AmitKumar Jain <amitjain@synechron.com>; +Cc: pgsql-admin
>>> AmitKumar Jain <amitjain@synechron.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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2008-12-16 14:50 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-12-08 08:40 How can we see details of function in psql prompt AmitKumar Jain <amitjain@synechron.com>
2008-12-08 08:49 ` AmitKumar Jain <amitjain@synechron.com>
2008-12-08 21:06 ` Milen A. Radev <milen@radev.net>
2008-12-08 09:12 ` AmitKumar Jain <amitjain@synechron.com>
2008-12-16 14:50 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox