Prerequisites
The RDS-PostgreSQL instance has been connected through pgAdmin and added to Servers.
Opening the Create Database Page
1. Select the desired RDS-PostgreSQL Servers in the Browser bar on the left and double-click Connect to open the menu options.
2. Click the Database column and right-click Create > Database... The Create box appears. The process is as follows:
Filling in Database-Related Information
In the create box, the information in each column is as follows:
General: Basic information (mandatory), including the database name and owner. The default owner is the user who started the database connection.
Definition: Basic configuration of database, including character encoding, template, table space, collation, character type, and connection restrictions. The default encoding mode is UTF-8. The remaining columns default to empty. This is an optional item.
Security: Permission configuration, including permission granting and security labels. This is an optional item.
Parameters: Role parameter (optional).
Advanced: Advanced option (optional).
SQL: After you fill in the previous items, the SQL for the created database is automatically generated, which cannot be filled in or modified.
After filling in, click Save to create the database.