Re: One more option for pg_dump...

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.