PG 创建库指定字符集

postgres=# \h create database

Command: CREATE DATABASE

Description: create a new database

Syntax:

CREATE DATABASE name

[ [ WITH ] [ OWNER [=] user_name ]

[ TEMPLATE [=] template ]

[ ENCODING [=] encoding ]

[ LC_COLLATE [=] lc_collate ]

[ LC_CTYPE [=] lc_ctype ]

[ TABLESPACE [=] tablespace ]

[ CONNECTION LIMIT [=] connlimit ] ]

--一个例子,指定字符集

CREATE DATABASE wap

WITH OWNER = wap

TEMPLATE = template0

ENCODING = 'UTF8'

TABLESPACE = tbs_wap;