Re: \df+ and pg_proc query

On Fri, 13 Jul 2001, Richard Huxton wrote:

> From: "Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu>
>
> > I assume that there is in fact a difference between doing:
> >
> > \df+ <func_name>
> >
> > and:
> >
> > select oid,proname,prosrc from pg_proc where proname='func_name';
> >
> > because I have a plpgsql function for a trigger, which I can see with the
> second method (the select...) but not with the first method (the \df+ ). Is
> it not possible to have the \df actually show up all functions?
>
> Start psql with -E and then do \df+ to see what query PG actually uses (this
> works for any \command)

I know that, but the question was: how come the \df doesn't show the plpgsql functions? Shouldn't it?

cheers,
thalis

>
> - Richard Huxton
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>