Create and Drop Database

Create Database

With CREATE DATABASE statement you can create a new database.

-- create a database called coffee
CREATE DATABASE coffee;

PostgreSQL docs

Remove database

Use DROP DATABASE statement to remove a database.

-- drop a database called coffe
DROP DATABASE coffee;

-- Force to drop the database if anyone is connected to it
DROP DATABASE coffee FORCE;

-- Doesn't thorw an error if database doesn't exist
DROP DATABASE IF EXISTS coffee;

PostgreSQL docs