Re: [HACKERS] psql commands for SQL/MED

2008-12-12 Thread Josh Berkus
Tom Lane wrote: Alvaro Herrera writes: \dew show foreign-data wrappers \des show foreign servers \deu show user mappings I'd prefer "external" rather than foreign, because new users could confuse the latter with "foreign keys". --Josh -- Sent via pgsql-hackers mailing list (pg

Re: [HACKERS] psql commands for SQL/MED

2008-12-12 Thread Tom Lane
Alvaro Herrera writes: > \dew show foreign-data wrappers > \des show foreign servers > \deu show user mappings Right, but maybe use "external" rather than "foreign" in the help so that people recognize what the mnemonic is. regards, tom lane -- Sent via pgsq

Re: [HACKERS] psql commands for SQL/MED

2008-12-12 Thread Alvaro Herrera
David Fetter wrote: > On Fri, Dec 12, 2008 at 08:24:36AM -0500, Tom Lane wrote: > > I'd suggest "e" for external. "M" for "management" is a pretty > > useless mnemonic --- what's being managed? > > \def, \deu, etc. sound great :) \dew show foreign-data wrappers \des show foreign servers

Re: [HACKERS] psql commands for SQL/MED

2008-12-12 Thread David Fetter
On Fri, Dec 12, 2008 at 08:24:36AM -0500, Tom Lane wrote: > Alvaro Herrera writes: > > Dimitri Fontaine wrote: > >> What about \dM prefix, M standing for MED? It seems free in my > >> 8.3 psql here. > > > So \dMf for foreign servers, \dMu for user mappings, etc? That > > seems good. > > I'd sug

Re: [HACKERS] psql commands for SQL/MED

2008-12-12 Thread Tom Lane
Alvaro Herrera writes: > Dimitri Fontaine wrote: >> What about \dM prefix, M standing for MED? It seems free in my 8.3 psql >> here. > So \dMf for foreign servers, \dMu for user mappings, etc? That seems good. I'd suggest "e" for external. "M" for "management" is a pretty useless mnemonic ---

Re: [HACKERS] psql commands for SQL/MED

2008-12-12 Thread Martin Pihlak
Alvaro Herrera wrote: >> What about \dM prefix, M standing for MED? It seems free in my 8.3 psql >> here. > > So \dMf for foreign servers, \dMu for user mappings, etc? That seems good. > I find the mixed case commands somewhat inconvinient -- too easy to make typing mistakes, also slow to ente

Re: [HACKERS] psql commands for SQL/MED

2008-12-12 Thread Alvaro Herrera
Dimitri Fontaine wrote: > Le 12 déc. 08 à 12:58, Peter Eisentraut a écrit : >> In an idle second I thought, how about F for "foreign", but of course >> \dF* is already used for full-text search. We could overload the F, >> but it might be weird. >> >> Other ideas? > > What about \dM prefix, M

Re: [HACKERS] psql commands for SQL/MED

2008-12-12 Thread Dimitri Fontaine
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, Le 12 déc. 08 à 12:58, Peter Eisentraut a écrit : The current proposed patch allocates the following psql \d commands: [...] In an idle second I thought, how about F for "foreign", but of course \dF* is already used for full-text search. We

[HACKERS] psql commands for SQL/MED

2008-12-12 Thread Peter Eisentraut
The current proposed patch allocates the following psql \d commands: \dw show foreign-data wrappers \dr show foreign servers \dm show user mappings One might object that this allocates valuable letters for infrequently used functionality. In an idle second I thought, how about F f