Skip site navigation (1) Skip section navigation (2)

Re: View user defined functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: "Charley L(dot) Tiggs" <ctiggs(at)xpressdocs(dot)com>,Postgres Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: View user defined functions
Date: 2005-10-18 15:39:30
Message-ID: 1453.1129649970@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Michael Fuhr <mike(at)fuhr(dot)org> writes:
> On Tue, Oct 18, 2005 at 09:43:51AM -0500, Charley L. Tiggs wrote:
>> How can I see the definition of a user defined function without  
>> dumping the database or the schema to a file?  I've been looking for  
>> a way to do this for about three weeks now, off and on and it's  
>> getting rather tedious to need to dump the schema every time I wish  
>> to change some part of a function.

> In psql you can use "\df+ functionname"; you could also issue a
> query like

> SELECT prosrc FROM pg_proc WHERE proname = 'functionname';

Also, I think that several of the available GUI packages (pgAdmin
etc) provide more comfortable means of editing function definitions.

			regards, tom lane

In response to

pgsql-novice by date

Next:From: Tadimeti, KesavDate: 2005-10-18 18:32:52
Subject: postgresql8.0.3/FreeBSD5.4/MIT or HEIMDAL KRB5
Previous:From: Michael FuhrDate: 2005-10-18 15:06:30
Subject: Re: View user defined functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group