Re: Consistent \d commands in psql - Mailing list pgsql-patches

From Tom Lane
Subject Re: Consistent \d commands in psql
Date
Msg-id 28526.1206978259@sss.pgh.pa.us
Whole thread Raw
In response to Re: Consistent \d commands in psql  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: Consistent \d commands in psql  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-patches
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

pgsql-patches by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Consistent \d commands in psql
Next
From: Andrew Dunstan
Date:
Subject: Re: Fwd: WIP: CASE statement for PL/pgSQL