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

From Greg Sabino Mullane
Subject Re: Consistent \d commands in psql
Date
Msg-id 27d0a5b6bcbe8c800d086429e43bf334@biglumber.com
Whole thread Raw
In response to Re: Consistent \d commands in psql  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Consistent \d commands in psql  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Consistent \d commands in psql  ("Brendan Jurd" <direvus@gmail.com>)
Re: Consistent \d commands in psql  (Bruce Momjian <bruce@momjian.us>)
List pgsql-patches
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


> \df Lists all user functions
> \df [pattern] Lists both system and user functions matching [pattern]
> \df * Lists all system and user functions

I don't like this for two reasons: the items returned changes based on
the existence of args, rather than on the command itself, and more
importantly, this would make it inconsistent with the other backslash
commands.

> One question: should \df really list *all* nonsystem functions?  Or just
> the ones that are visible in your search path?  I'd be inclined to say
> the second.

Agreed, we should respect the search path like the other commands do.
Although I wonder if a long-term idea would be to at least indicate
that there are other same-named things in your path?

- --
Greg Sabino Mullane greg@endpoint.com  greg@turnstep.com
End Point Corporation 610-983-9073
PGP Key: 0x14964AC8 200804020915
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAkfzh0IACgkQvJuQZxSWSsgTCgCdEv1vl7c0uIpIU3pSiH/VLvEg
m5wAni5/gJ0K2w1gpaNaWpVFCRJX200f
=ZnTm
-----END PGP SIGNATURE-----



pgsql-patches by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: Friendly help for psql
Next
From: Tom Lane
Date:
Subject: Re: Consistent \d commands in psql