4

This question deals with getting a list. So I get this:

$ psql --list List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges ----------------+----------+----------+-------------+-------------+----------------------- testdb1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | odoo | openerp | UTF8 | en_US.UTF-8 | en_US.UTF-8 | odoo-demo | openerp | UTF8 | en_US.UTF-8 | en_US.UTF-8 | odoo8 | openerp | UTF8 | en_US.UTF-8 | en_US.UTF-8 |

I could use psql --list|grep UTF8|awk '{ print $1 }' to get a list of just the databases. Can psql also give me a clean useful list directly?

Improve this question
3
  • The answer is the same, the question title is quite different though. I wouldn't have looked there if I had seen that title. Commented Aug 8, 2014 at 12:46
  • Agreed, I've changed the title for something more descriptive. But anyway the -Atc switches should be mentioned in the answers of the much more popular question you linked. Commented Aug 8, 2014 at 15:45
  • <1k vs >15k views - by now this question has vastly surpassed the other question in popularity. Commented Jan 28, 2018 at 10:20

1 Answer 1

Reset to default
6

psql -q -A -t -c "SELECT datname FROM pg_database" does the trick.

Improve this answer

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.