Feb 17, 2011 · When I log in with psql --username=postgres, how do I list all databases and tables? I have tried \d, d and dS+ but nothing is listed. I have created two databases and a few tables with …

Jul 23, 2025 · In this article, we will explain how to list databases and tables in PostgreSQL using the psql command-line interface. We will cover both basic and advanced concepts to ensure solid …

Nov 23, 2023 · List all databases in PostgreSQL using one of the three methods provided in this simple tutorial. The tutorial covers CLI and GUI methods.

Most Postgres servers have three databases defined by default: template0, template1 and postgres. template0 and template1 are skeleton databases that are or can be used by the CREATE …

Apr 26, 2025 · As a database administrator or developer, one of the fundamental tasks you’ll often need to perform is listing databases and tables within PostgreSQL. In this step-by-step tutorial, we will …

Jun 25, 2025 · Having a complete view of all your databases in PostgreSQL is essential for effective database management. This guide explores six proven methods you can use to quickly list all of your …

Jan 4, 2024 · Start the psql command-line utility. Type the extbackslash l or extbackslash list meta-command. Press Enter to see the list of databases. Advantages: Quick and easy to use. No need for …

This article describes two methods for listing databases in PostgreSQL. In PostgreSQL, you can use two methods to list all databases in a PostgreSQL server: Use \l or \l+ to list all databases in the psql tool. …

Feb 7, 2024 · Summary: in this tutorial, you will learn how to show databases in a PostgreSQL database server. In MySQL, you can show all databases in the server using SHOW DATABASES statement. …

May 3, 2023 · Getting the list of databases in Postgres is one of the most common operations performed by developers and DBAs. There are several ways to achieve that, depending on preferences, …