Postgres Pro
Downloads
Home   >   mailing lists

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

From Pavel Stehule
Subject option for psql - short list non template database
Date
Msg-id CAFj8pRDFimVkLmaHfSKBx-7szbbgzgsX3swxnhGVBZ6sLjPzUA@mail.gmail.com
Whole thread Raw
Responses Re: option for psql - short list non template database  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view
Hi

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

Regards

Pavel

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: [DESIGN] Incremental checksums
Next
From: Amit Kapila
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Map basebackup tablespaces using a tablespace_map file