When working with multiple PostgreSQL databases at the same time, it is essential to know how to list them. It can be necessary when you are getting familiar with a new environment or performing server maintenance.
This article, provide you with an illustrated guide on how to show databases in PostgreSQL, filter them, and order them according to certain criteria. You'll find out about:
How to show databases from the command line
What is the basic syntax
How to filter the database list
How to sort the database list
What permissions are required to get the list of databases
How to get and manage a database list with a PostgreSQL GUI tool