On Wed, Feb 27, 2008 at 2:29 PM, Joshua D. Drake <jd@commandprompt.com> wrote:
> > You could just pull up a psql session and do a "select
> > pg_func_def(regproc);" and there you go, one fully formed CREATE
> > FUNCTION statement.
>
> \df+ function(type)
>
Sure, if your idea of a good time is looking at the output of \df+,
and then querying pg_proc anyway to find out whether the function is
strict or not, and then writing out a CREATE FUNCTION by hand. \df+
is great for getting a quick idea of what functions are available and
what they do. For producing executable SQL to re-create those
functions, it's a mess.