2015-07-17 18:56 GMT+02:00 Robert Haas <robertmh...@gmail.com>: > On Thu, Jul 16, 2015 at 12:21 AM, Pavel Stehule <pavel.steh...@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 >