In this article, we would like to show you how to create database in PostgreSQL.
CREATE DATABASE "database_name";
CREATE DATABASE example
In this example, we will create a new database -
CREATE DATABASE "diraskDB";
CREATE DATABASE IF NOT EXISTS example
You can optionally add
IF NOT EXISTS statement, so if the database already exists you won't get an error.
CREATE DATABASE IF NOT EXISTS "diraskDB";
If you try to create a database that already exists with
CREATE DATABASE query you will get an error:
If you try to
CREATE DATABASE IF NOT EXIST you will get a warning instead: