(1) select procsrc from pg_proc where proname like '<function_name>';
(2) df+ <function_name>
--
Thanks
Sam Jas
--- On Fri, 11/12/09, Venkateswara Rao Bondada <venkateswar...@infosys.com>
wrote:
From: Venkateswara Rao Bondada <venkateswar...@infosys.com>
Subject: [ADMIN] How to view the code of a function
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Date: Friday, 11 December, 2009, 9:58 AM
Hi,
I’m trying to look at the source code of a function in
PostgreSQL. Could anybody please let me know how to view the same?
Thanks,
Venkat
**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
for the use of the addressee(s). If you are not the intended recipient, please
notify the sender by e-mail and delete the original message. Further, you are
not
to copy, disclose, or distribute this e-mail or its contents to any other
person and
any such actions are unlawful. This e-mail may contain viruses. Infosys has
taken
every reasonable precaution to minimize this risk, but is not liable for any
damage
you may sustain as a result of any virus in this e-mail. You should carry out
your
own virus checks before opening the e-mail or attachment. Infosys reserves the
right to monitor and review the content of all messages sent to or from this
e-mail
address. Messages sent to or from this e-mail address may be stored on the
Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
http://in.yahoo.com/
