Re: option for psql - short list non template database - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: option for psql - short list non template database
Date
Msg-id CAFj8pRAzMjwrGPmO61duAFHFZcgxvCEhUi3soa2H+X0bt-F95w@mail.gmail.com
Whole thread Raw
In response to Re: option for psql - short list non template database  (Robert Haas <robertmhaas@gmail.com>)
List 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 by date:

Previous
From: Robert Haas
Date:
Subject: Re: option for psql - short list non template database
Next
From: Andrew Gierth
Date:
Subject: Re: GSets: Getting collation related error when GSets has text column