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@xxxxxxxxxxxxxx
[mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of AmitKumar Jain
Sent: Monday, December 08, 2008 3:41 AM
To: pgsql-admin@xxxxxxxxxxxxxx
Subject: 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
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
