Creating a Database

Procedure

1. In the database list of the Home page, click Create Database.
2. On the displayed page, enter a database name and select a character set.
   

   You can execute the following SQL statement to query system table pg_collation and view character sets and their corresponding collations and collation types:

   select pg_encoding_to_char(collencoding) as encoding,collname,collcollate,collctype from pg_collation ;

3. Click OK. The database you create appears in the database list.