Help Center> Relational Database Service> Best Practices> RDS for PostgreSQL> Creating Databases> CREATE DATABASE Options
Updated on 2022-11-02 GMT+08:00
View PDF

CREATE DATABASE Options

When creating databases, you can specify a template database and set different character sets and collations for each database.

This section describes how to use the CREATE DATABASE command to configure the template database, character set, LC_COLLATE, and LC_CTYPE. For details about other parameters, see the official documentation. 
CREATE DATABASE name    
[ [ WITH ] [ OWNER [=] user_name ]           
       [ TEMPLATE [=] template ]           
       [ ENCODING [=] encoding ]           
       [ LC_COLLATE [=] lc_collate ]           
       [ LC_CTYPE [=] lc_ctype ]           
       [ TABLESPACE [=] tablespace_name ]          
       [ ALLOW_CONNECTIONS [=] allowconn ]           
       [ CONNECTION LIMIT [=] connlimit ]          
       [ IS_TEMPLATE [=] istemplate ] ]