CREATE USER dbuser WITH PASSWORD 'dbpassword|';
CREATE DATABASE "dbname"
WITH OWNER "dbuser"
ENCODING 'UTF8'
LC_COLLATE = 'fr_FR.UTF-8'
LC_CTYPE = 'fr_FR.UTF-8'
TEMPLATE template0;
Création en bash :
createuser [user]
createdb [database] --encoding='utf-8' --locale=fr_FR.utf8 --template=template0
GRANT ALL privileges ON DATABASE dbname TO dbuser;