PostgreSQL - Create Database

In this tutorial you'll learn how to create database in PostgreSQL using both-

1. SQL shell (command line)
2. pgAdmin4 (Graphical interface)

Creating DB using SQL shell

Command that you can use to create a new DB is-

CREATE DATABASE dbname;

1. Open SQL shell, provide the user name and password to connect to server.
2. Type command CREATE DATABASE testdb; to create a database named testdb.

How to Install PostgreSQL on Windows

In this tutorial we'll see how to download and install PostgreSQL database on Windows 10.

Downloading Postgre

You can download PostgreSQL installer from the URL given below-

https://www.postgresql.org/download/windows/

Click on Download the installer.

In the next page Select the version of PostgreSQL you want to download by clicking on download button. Select the location where you want to download the exe file.

PostgreSQL Installation Steps

1. Go to the location where you have downloaded the .exe file and double click to start the installation process. In the setup window click on next.