RDS for PostgreSQL
RDS for PostgreSQL
RDS for PostgreSQL
Document
What's new
Product announcement
Overview
Billing
Quick start
User guide
Managing instances
Modifying the specification
Managing tags
Managing connections
Connecting to an instance
Managing connection endpoints
Service availability
Managing accounts
Managing databases
Managing schemas
Monitoring and alerts
Backup recovery
Data backup
Managing logs
Data security
Managing the allowlist (new version)
Configuring SSL encryption
Configuring parameters
Operation and maintenance events
Task center
Extensions
API reference
V2(2022-01-01)
Managing instances
Managing accounts
Managing schemas
Managing connections
Managing parameters
Backup and recovery
Managing logs
Event management
Data security
Task management
SDK reference
Developer tool
Best practices
Performance document
FAQs
Terms
- Documentation
RDS for PostgreSQL API referenceV2(2022-01-01)Managing schemasModifySchemaOwner
Copy page
Download PDFManaging schemas
ModifySchemaOwner
Copy pageDownload PDFModifySchemaOwner
Call the ModifySchemaOwner API to modify the schema owner.
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 |
Parameter | Type | Required? | Example | Description |
InstanceId | String | Yes | postgres-21a3333b**** | Instance ID. |
SchemaInfo | Yes | Refer to the request example. | Schema information. |
SchemaObject
Parameter | Type | Required? | Example | Description |
Parameter | Type | Required? | Example | Description |
DBName | String | Yes | testdb | Database name. |
SchemaName | String | Yes | testschema | Schema name under the database. |
Owner | String | Yes | testuser | Schema owner. tip Instance read-only accounts, super accounts or normal accounts with DDL privileges disabled cannot be used as database owners. |
Response parameters
null
Sample
Sample request
POST /?Action=ModifySchemaOwner&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****",
"SchemaInfo": [
{
"DBName": "testdb1",
"Owner": "testuser",
"SchemaName": "testschema"
}
]
}
Sample response
{
"ResponseMetadata": {
"RequestId": "202308041041567B21482F51ABF904517D",
"Action": "ModifySchemaOwner",
"Version": "2022-01-01",
"Service": "rds_postgresql",
"Region": "cn-beijing"
},
"Result": null
}
Last updated: 2026.03.31 10:45:18
All rights reserved © Beijing Volcano Engine Technology Co., Ltd2024
