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
SELECT prosrc FROM pg_proc WHERE proname = 'functionname';
Note that neither of these methods returns the complete CREATE
FUNCTION statement that you might be looking for.
Some people maintain the source for their functions outside the
database so they can do "edit-load" instead of "dump-edit-load."
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2005-10-18 15:39:30|
|Subject: Re: View user defined functions |
|Previous:||From: Charley L. Tiggs||Date: 2005-10-18 14:43:51|
|Subject: View user defined functions|