...
Code Block |
---|
sudo -u postgres psql -c 'CREATEcreate DATABASEdatabase newid WITH OWNER "postgres" ENCODING "UTF8" LC_COLLATE = "en_US.UTF-8" LC_CTYPE = "en_US.UTF-8" TEMPLATE template0;';' |
If you want to encode in UTF8
Code Block |
---|
sudo -u postgres psql -c "create database newid with encoding='utf8' template=template1;" |
Code Block |
---|
CREATE DATABASE "helpspotdb_db"name
OWNER = WITH OWNER "postgres"role_name
TEMPLATE = template
ENCODING 'UTF8'
= encoding
LC_COLLATE = 'en_US.UTF-8'collate
LC_CTYPE = ctype
LC_CTYPETABLESPACE = 'en_US.UTF-8'tablespace_name
CONNECTION LIMIT TEMPLATE template0;= max_concurrent_connection
WITH ENCODING='UTF8' |