Re: option for psql - short list non template database

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: option for psql - short list non template database
Дата
Msg-id CAFj8pRAzMjwrGPmO61duAFHFZcgxvCEhUi3soa2H+X0bt-F95w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: option for psql - short list non template database  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers


2015-07-17 18:56 GMT+02:00 Robert Haas <robertmhaas@gmail.com>:
On Thu, Jul 16, 2015 at 12:21 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> terrible often I use pattern
>
>  psql -c "select datname from pg_database where not datistemplate and
> datallowconn" postgres
>
> What about introduction new long option that does it?
>
> psql -At -list --names --without-templates

I think you should just put an alias in your .bashrc file.  If we add
everyone's favorite shortcuts to every tool, we will end up with an
unsupportable number of features that are each of interest to only a
very few people.

sure - but taking list of databases and iteration over this list is pretty common task.

Pavel
 

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: option for psql - short list non template database
Следующее
От: Andrew Gierth
Дата:
Сообщение: Re: GSets: Getting collation related error when GSets has text column