You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

sudo -u postgres psql -c 'create database newid;'

If you want to encode in UTF8

sudo -u postgres psql -c "create database newid with encoding='utf8' template=template1;"
CREATE DATABASE db_name
 OWNER =  role_name
 TEMPLATE = template
 ENCODING = encoding
 LC_COLLATE = collate
 LC_CTYPE = ctype
 TABLESPACE = tablespace_name
 CONNECTION LIMIT = max_concurrent_connection


WITH ENCODING='UTF8'
  • No labels