Category: Database

The Drop/delete command is used to eternally delete all the file entries and data directory from the PostgreSQL platform. Therefore, we have to use this command very carefully. In this section, we are going to learn how to drop or delete the database, which we don’t need any more in PostgreSQL. In PostgreSQL, we can drop the database…

In this section, we are going to discuss how we can access or select the database in PostgreSQL. In our previous section of the PostgreSQL tutorial, we have already created a database. And, now we are going to select the database with the help of various methods. In PostgreSQL, we have two methods to select the database: Database…

In this section, we are going to discuss how we can create a database in PostgreSQL. In PostgreSQL, we can create a database in two ways: Creating Database using pgAdmin To create a database in pgAdmin, we are going to follow the below steps: Step 1 Databases → Create → Database Step 2 Step 3 Step…

In this section, we are going to understand how to connect the PostgreSQL database server through an interactive terminal software called pgAdmin and the SQL Shell(psql) application. If we installed the PostgreSQL database server, then the PostgreSQL installer will also connect with some beneficial tools to work through the PostgreSQL database server. Here, we are going to discuss how we can…