You need to enable JavaScript to run this app.
RDS for PostgreSQL

RDS for PostgreSQL

  • Documentation
    • RDS for PostgreSQL API referenceV2(2022-01-01)Managing schemasCreateSchema
Copy page
Download PDF
Managing schemas
CreateSchema
Copy page
Download PDF
CreateSchema
Call the CreateSchema API to create a schema.​
Request type​
Synchronous request.​
Debug​
API Explorer
You can initiate calls online through API Explorer without paying attention to the signature generation process and quickly obtain the call results.
​
Request parameters​
​
Parameter​
Type​
Required?​
Example​
Description​
InstanceId​
String​
Yes​
postgres-21a3333b****​
Instance ID.​
DBName​
String​
Yes​
testdb1​
Database name.​
SchemaName​
String​
Yes​
ThisIsASchemaName​
Schema name.​
  • The name length is limited to 2–63 characters.​
  • Consists of letters, digits, underscores (_), or hyphens (-).​
  • Must start with a letter and end with a letter or a digit.​
  • Reserved words cannot be used. For all disabled keywords, refer to disabled keywords.​
  • Cannot start the name with pg_.​
Owner​
String​
Yes​
User01​
Schema owner.​
tip​
Instance read-only accounts, super accounts or normal accounts with DDL privileges disabled cannot be used as schema owners.​
​
Response parameter​
null​
Sample​
Sample request​
​
POST /?Action=CreateSchema&Version=2022-01-01 HTTP/1.1​
Content-Type: application/json​
Host: rds-postgresql.cn-beijing.volcengineapi.com​
X-Date: 20231002T101010Z​
Authorization: HMAC-SHA256 Credential=AKLTN2I0MmFiNzMxNWE5NDgzMzk4MmVjMTVkODlkZTZ****/20211202/cn-beijing/rds_postgresql/request,SignedHeaders=x-date, Signature=71d31fc7bcf990142851c9833c5656391486cda0ae2e0b8ada733b7c6458****​
{​
"InstanceId": "postgres-ca7b7019****",​
"DBName": "testdb1",​
"SchemaName": "testschema",​
"Owner": "User01"​
}​
​
Sample response​
​
{​
"ResponseMetadata": {​
"RequestId": "202308041039157B21482F51ABF9040FDC",​
"Action": "CreateSchema",​
"Version": "2022-01-01",​
"Service": "rds_postgresql",​
"Region": "cn-beijing"​
},​
"Result": null​
}​
​
Last updated: 2026.03.31 10:45:18