Re: Consistent \d commands in psql

Gregory Stark <stark@enterprisedb.com> writes:
> One --perhaps nice, perhaps not-- property of this is that if you defined a
> function named "rtrim" and then did "\df rtrim" it would show you _both_ the
> system and user function and make it easier to see the conflict. Whereas the
> other behaviour I proposed would hide the system function which might
> exacerbate the user's confusion.

Yeah, that is a very good point indeed.

Another way we could approach this is

    \df    -> all functions
    \dfS    -> sys functions only
    \dfU    -> user functions only

which avoids falling into the trap Greg mentions.

            regards, tom lane