Re: print out custom functions - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: print out custom functions
Date
Msg-id 20011120164003.A23836@mgc.pl
Whole thread Raw
In response to print out custom functions  ("Thomas T. Thai" <tom@minnesota.com>)
List pgsql-general
On Tue, Nov 20, 2001 at 04:04:38AM -0600, Thomas T. Thai wrote:
> /df myFunctionName descibes my function. is it possible to display the
> code that made up that function in psql?

select prosrc from pg_proc where proname = 'myFunctionName';

can have some side effects, but usually works.

depesz

--
hubert depesz lubaczewski                          http://www.depesz.pl/
------------------------------------------------------------------------
... vows are spoken to be broken ...                 [enjoy the silence]
... words are meaningless and forgettable ...             [depeche mode]

pgsql-general by date:

Previous
From: Jodi Kanter
Date:
Subject: database cluster
Next
From: "Alexander Chupin"
Date:
Subject: Explain plan in java program