On Wed, Feb 27, 2008 at 2:29 PM, Joshua D. Drake <[EMAIL PROTECTED]> 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.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
