Re: Separate psql commands from arguments

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: Separate psql commands from arguments
Дата
Msg-id 871w5lfcox.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Separate psql commands from arguments (was: psql command aliases support)  ("Brendan Jurd" <direvus@gmail.com>)
Ответы Re: Separate psql commands from arguments  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: Separate psql commands from arguments  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Separate psql commands from arguments  ("Brendan Jurd" <direvus@gmail.com>)
Re: Separate psql commands from arguments  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers

"Brendan Jurd" <direvus@gmail.com> writes:

> +1 for dropping this quirk.  And, if there are no objections (or other
> takers), I volunteer to write a patch.

Regardless of whether we go ahead with this (and I'm not fond of it primarily
because I want \c& to "work"), I think we would still be better off keeping
the aliases in a separate namespace from psql commands and having an explicit
command for calling them.

I also don't see any point in allowing aliases which call other psql commands.
psql is not a particularly nice and well defined interface and it would just
make it that much more complex and confusing.

I still see it much cleaner and much clearer for people reading the script to
have something like

\query dpkg perl-base*

Than to have something like

\dpkg perl-base*

which looks like it might be related to \dp in some way the way (like how \dFp
is related to \dF).

It would also mean that if you try to run a query which doesn't exist you
won't accidentally type a real command or get a "command not found" error.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production
Tuning


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Garbage pad bytes within datums are bad news
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Separate psql commands from arguments