via kinsta.com => original post link
PostgreSQL, otherwise known as Postgres, is an open-source object-relational database system that enables you to store and scale complex data workloads safely. It uses and extends SQL, the language that enables users to access databases.
To manage a Postgres database server effectively, you must be familiar with your environment and what the server stores. Sometimes, you may need to list the databases running on your server, retrieve information about them, and connect to them. You can complete these tasks using the PostgreSQL interface or a graphical tool like Adminer to easily view and manipulate this information.
If your database is just one of several on the Postgres server, you may need to filter the list to find it. Then, you’ll often need an overview of the data it contains, requiring a list of its tables. This hands-on guide demonstrates how to list databases and tables in Postgres.