Re: How to view the code of a function

(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 <Venkateswara_B(at)infosys(dot)com> wrote:

From: Venkateswara Rao Bondada <Venkateswara_B(at)infosys(dot)com>
Subject: [ADMIN] How to view the code of a function
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)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/