| From: | hubert depesz lubaczewski <hl(at)mgc(dot)pl> |
|---|---|
| To: | "Thomas T(dot) Thai" <tom(at)minnesota(dot)com> |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: print out custom functions |
| Date: | 2001-11-20 15:40:03 |
| Message-ID: | 20011120164003.A23836@mgc.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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]
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Link | 2001-11-20 16:10:01 | Performance: Perl-DBI vs. PG Stored Procedures |
| Previous Message | Fran Fabrizio | 2001-11-20 15:29:35 | Slightly OT: outer joins |