Re: option for psql - short list non template database

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: option for psql - short list non template database
Date: 2015-07-17 16:56:29
Message-ID: CA+TgmobgZhPj9VoJtNnmp4Limz0k4Pa5kNqrYL4cdKtwYosFXA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2015-07-17 17:02:04 Re: option for psql - short list non template database
Previous Message Robert Haas 2015-07-17 16:53:07 Re: Retrieve the snapshot's LSN