Re: viewing function source code

From: "Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar(dot)Pyatalo(at)honeywell(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar(dot)Pyatalo(at)honeywell(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: viewing function source code
Date: 2004-08-31 06:28:21
Message-ID: 77ED2BF75D59D1439F90412CC5B1097410F0A73F@ie10-sahara.hiso.honeywell.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


That worked, Thanks a lot Tom.

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Tuesday, August 31, 2004 11:30 AM
To: Pradeepkumar, Pyatalo (IE10)
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] viewing function source code

"Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar(dot)Pyatalo(at)honeywell(dot)com> writes:
> Is there a way wherein I can
> look into the function sourcecode from within the database.

\df+ ... but really what you want to do is run pg_dump (possibly with -s
option) to extract the function definitions in a reloadable form.

regards, tom lane

Browse pgsql-novice by date

  From Date Subject
Next Message Dmitry Karasik 2004-08-31 07:44:16 First query slow, subsequent queries fast
Previous Message Tom Lane 2004-08-31 05:59:48 Re: viewing function source code