Prerequisites
• You have viewing or higher permissions to the instance.
• The database type of the current instance is PostgreSQL.
Procedure
1. Log in to DMS.
2. On the left menu bar, click Data Source Management > Instance Metadata to go to the Instance List page.
3. Go to the Operate menu bar of the target instance and click the Database List button to go to the database management page.
4. Go to the Operate menu bar of the database list and click Schema List to go to the Schema List page.
5. Click the Synchronize Metadata button to obtain the real-time metadata information of the database.
Description of the Schema List Function Item:
Functional Item | Description |
Create Schema | Allows you to create a schema and synchronize the schema metadata of the current database. |
Schema Search | Allows you to search for the schema under the current database. A fuzzy search by schema name is supported. |
Schema Switch | Displays the basic information about the current database. You can switch databases using the dropdown box and display the schema list of different databases. |
Schema List | Displays the basic information about the schema, including schema name, owner, and comments. |
Schema Operation | Allows you to navigate to the list page of the subordinate objects, navigate to the query window page, and delete databases. |
Schema Management
The database type is the PostgreSQL series.
Creating a Schema
1. Log in to DMS.
2. On the Instance List page, click the Database List button to go to the Database Management page.
3. Go to the Operate menu bar of the database list and click Schema List to go to the Schema List page.
4. Click the Create Schema button and enter the optional parameters as required.
5. Click the OK button to finish creating the schema.
The parameters for schema creation are described below:
Parameter | Mandatory or Not | Description |
Schema Name | Yes | Specifies the name of the schema to be created. |
Owner | Yes | Specifies the owner of the schema. |
Comment | No | Displays the remarks information for the current schema. |
Deleting a Schema
Go to the Operate menu of the schema list and click the Delete button. After re-confirmation, finish deleting the target schema.