Re: Consistent \d commands in psql

On Tue, Apr 01, 2008 at 12:58:44AM -0400, Tom Lane wrote:
> Gregory Stark <stark(at)enterprisedb(dot)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.
>
> >> Another way we could approach this is ...
>
> > That doesn't satisfy the original source of the annoyance which is
> > that \df spams your terminal with ten screens of system functions
> > with your user functions hidden amongst them.
>
> Sure, but I think the core objection there is that there is no easy
> way to see only the user-defined functions. Given your point quoted
> first above, I'm unconvinced that should be the default behavior.

When we have a bad default--and I'd argue that for anyone not
developing PostgreSQL itself, showing system functions is a bad
default--we should change it to something sane.

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate