Using the PostgreSQL List Databases Command
You will often need to list the databases or even tables when working with databases. Like most database servers, Postgres has a command-line-based tool that allows you to manage your Postgres server.
This tool ispsql. It allows you to type in queries, execute them and display the results. You can use psql to list databases and show tables in Postgres with some simple commands.
Getting Set Up
To connect to the server and list databases or tables, you’ll need to have PostgreSQL installed. Here are some helpful tutorials:
Listing Databases in PostgreSQL
Once you connect to the database using thepsqlcommand, you can list all the databases in the connected server using the following command.
This is a shortcut for the\listcommand.
This command will list at least the three default databases: postgres, template0, and template1. postgres is the first database you will connect to if you have not yet created another database.
You can create a new database using the following command.
Once you have created the database, you will need to switch to it in order to insert data and perform other operations on it.
Listing Tables in PostgreSQL
After connecting to the database and creating tables, you may want to know what tables exist. you may do this by listing the tables using the psql command,\dt.
If no tables exist this command will show aDid not find any relationsmessage. Otherwise, it will display the tables in a tabular format.
For example, create a table named users in a database called blog using the following command.
If you list the tables using the\dtcommand, the output will be similar to the one shown below.
Managing Your PostgreSQL Database
There are a couple of simple psql commands you may use to list databases and show tables in a PostgreSQL server. They are just two of the many commands that the psql tool offers.
However, if you want an easy-to-use GUI application to manage your PostgreSQL database, opt for the pgAdmin tool. Using pgAdmin, you can interact with your server without using the command line.
Configuring a database is hard, but managing it is even harder. Here’s how to install pgAdmin on Ubuntu to manage your PostgreSQL database.
These are the best free movies I found on Tubi, but there are heaps more for you to search through.
Quality apps that don’t cost anything.
These films will leave you questioning humanity, but also wanting more.
You can’t call this offline, Notion.
These plugins will make you wonder why you used Photoshop in the first place.
