Re: viewing function source code - Mailing list pgsql-novice

From Pradeepkumar, Pyatalo (IE10)
Subject Re: viewing function source code
Date
Msg-id 77ED2BF75D59D1439F90412CC5B1097410F0A73F@ie10-sahara.hiso.honeywell.com
Whole thread Raw
In response to viewing function source code  ("Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar.Pyatalo@honeywell.com>)
List pgsql-novice
That worked, Thanks a lot Tom.


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


"Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar.Pyatalo@honeywell.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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: viewing function source code
Next
From: Dmitry Karasik
Date:
Subject: First query slow, subsequent queries fast