PostgreSQL — Create Database

Basic Create

CREATE DATABASE mydb;

With Owner

CREATE DATABASE mydb WITH OWNER = user1;

With Encoding

CREATE DATABASE mydb
    ENCODING = 'UTF8'
    LC_COLLATE = 'en_US.UTF-8'
    LC_CTYPE = 'en_US.UTF-8';

Template

CREATE DATABASE mydb TEMPLATE = template0;

Connection Limit

CREATE DATABASE mydb CONNECTION LIMIT = 100;

Conditional Create

CREATE DATABASE IF NOT EXISTS mydb;

Using Createdb

createdb -U postgres mydb

Mini Practice

1. Create a basic database
2. Set owner and encoding
3. Use connection limits
4. Create with template

Up Next

Continue with Drop Database — dropping databases.