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