Docs

RDS for PostgreSQL

User guide

Data management

RDS for PostgreSQL has been connected to Database Workshop (DBW), providing visual data management functions in DBW.

Function introduction

The data management function relies on DBW's data interaction platform to implement a visual operation interface. In the data interaction platform, you can perform the following operations:

Execute SQL commands. For more details, refer to Command operations.

Manage the database lifecycle, including creating database, modifying database, and Delete database. For more details, refer to Databases.

Manage the table lifecycle, including viewing tables, creating tables, Add data, modifying data, and deleting tables. For more details, refer to Schema management.

Manage the full lifecycle of a schema, including creating, editing, and deleting schemas. For more information, refer to Table management.

The RDS for PostgreSQL workbench has two entrances: the instance list of RDS for PostgreSQL and the Database Workshop.

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 Login DBW in the actions column of the target instance. In the pop-up Database DBW dialog box, set the following parameters and check Authorize the Database Workshop to add service IPs to the corresponding database instance allowlist, and then click Login.

Parameters	Note
Instance types	Confirm that the instance type is RDS for PostgreSQL.
Instance name/ID	Confirm that the instance is the target instance. Other instances can be switched from the drop-down list.
Database account	Enter the database account name.
Database password	Enter the database account password.

For details, see Log in database interaction platform.

Last updated: 2025.11.17 16:15:02