Docs

RDS for PostgreSQL

Managing schemas

Creating a schema

Creating a schema

This topic introduces how to create a schema.

Prerequisites

You have Creating an instance, and the instance is in the Running status.

A database has been created.

Procedure

Login to the RDS for PostgreSQL console.

In the upper-left corner of the top menu bar, select the project and region for the instance.

tip

If the project of the instance has not been set, the project should be selected as All resources.

On the Instances page, click on the target instance name.

On the Summary page, click Databases.

On the Databases tab, click Manage Schema in the Actions column of the target database.

tip

You can also click the Schema tab to enter the Schema management page.

In the dropdown list to the right of Create Schema at the top left of the page, select the database to which the Schema belongs.

Click Create Schema, and set the following parameters in the pop-up dialog box.

Parameters	Note
Database name	Not required to set, it is the database selected in step 6.
Schema	Enter the schema name. Requirements are as follows: The name is unique. Can contain letters, digits, underscores (_) and hyphens (-). Must start with a letter and end with a letter or a digit. 2 to 63 characters in length. Some reserved words or keywords cannot be used in the schema name, see List of reserved keywords for all reserved keywords. Do not start the name with pg_.
Schema Owner	Select an account to manage the schema in the drop-down list, the account has the owner permission of the schema. The schema owner can be modified after creation. For more details, refer to Modifying schema owner. tip Instance read-only accounts, super accounts with DDL privileges disabled, or normal accounts with DDL privileges disabled cannot be used as schema owners.

Click OK to complete the Schema creation.

Last updated: 2025.11.17 16:15:06