Postgres examples

create a basic table with utf8 encoding

CREATE DATABASE "example" WITH OWNER "user" \
ENCODING 'UTF8' LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8' \
TEMPLATE template0;