From: AmitKumar Jain <amitjain@synechron.com>
To: Hoover, Jeffrey <jhoover@jcvi.org>
Cc: pgsql-admin@postgresql.org
Subject: Re: How can we see details of function in psql prompt
Date: Mon, 08 Dec 2008 14:19:15 +0530
Message-ID: <493CDF8B.3060307@synechron.com> (raw)
In-Reply-To: <E92C2B1CB12A7A4683697273BD5DCCE402DF0D52@EXCHANGE.TIGR.ORG>
References: <493CDD91.40205@synechron.com>
<E92C2B1CB12A7A4683697273BD5DCCE402DF0D52@EXCHANGE.TIGR.ORG>
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
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: amitjain@synechron.com, jhoover@jcvi.org
Subject: Re: How can we see details of function in psql prompt
In-Reply-To: <493CDF8B.3060307@synechron.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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