Overview

Postgresql is... To create database:

create database test;

To Create table:

create table x(id varchar(20) primary key);

create table customer(id varchar(20) primary key, fname varchar(50) not null, lname(50) not null unique);