Re: option for psql - short list non template database

2015-07-17 18:56 GMT+02:00 Robert Haas <robertmhaas(at)gmail(dot)com>:

> On Thu, Jul 16, 2015 at 12:21 AM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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
>