create database 库名 with owner 属主 template template0 encoding 'GBK' lc_collate 'zh_CN.GBK' lc_ctype 'zh_CN.GBK';
CREATE DATABASE “test_db”
WITH OWNER “postgres”
ENCODING ‘UTF8’
LC_COLLATE = ‘en_US.UTF-8’
LC_CTYPE = ‘en_US.UTF-8’
TEMPLATE template0;