Release Notes and Announcements

Release Notes

Product Announcements

Product Introduction

Overview

Features

Strengths

Scenarios

Information Security

Regions and AZs

Product Feature List

Large version lifecycle description

MSSQL Compatible Version

Billing

Billing Overview

Instance Type and Specification

Purchase Methods

Refund

Overdue Payments

Backup Space Billing

Database Audit Billing Overview

Getting Started

Creating TencentDB for PostgreSQL Instance

Connecting to TencentDB for PostgreSQL Instance

Managing TencentDB for PostgreSQL Instance

Importing Data

Migrating Data with DTS

Kernel Version Introduction

Kernel Version Overview

Kernel Version Release Notes

Viewing Kernel Version

Proprietary Kernel Features

Database Audit

Audit Service Description

Activating Audit Service

View Audit Logs

Modify audit services

Audit Performance Description

User Guide

Instance Management

Upgrading Instance

CPU Elastic Scaling

Read-Only Instance

Account Management

Database Management

Parameter Management

Log Management and Analysis

Backup and Restoration

Data Migration

Extension Management

Network Management

Access Management

Data Security

Tenant and Resource Isolation

Security Groups

Monitoring and Alarms

Tag

AI Practice

Using the Tencentdb_ai Plug-In to Call Large Models

Building Ai Applications with the Tencentdb Ai Plug-In

Combining Supabase to Quickly Build Backend Service Based on TencentDB for PostgreSQL

Use Cases

postgres_fdw Extension for Cross-database Access

Automatically Creating Partition in PostgreSQL

Searching in High Numbers of Tags Based on pg_roaringbitmap

Querying People Nearby with One SQL Statement

Configuring TencentDB for PostgreSQL as GitLab's External Data Source

Supporting Tiered Storage Based on cos_fdw Extension

Implement Read/Write Separation via pgpool

Implementing Slow SQL Analysis Using the Auto_explain Plugin

Using pglogical for Logical Replication

Using Debezium to Collect PostgreSQL Data

Set Up a Remote Disaster Recovery Environment for PostgreSQL Locally on CVM

Read-Only Instance and Read-Only Group Practical Tutorial

How to Use SCF for Scheduled Database Operations

Fix Table Bloat

Performance White Paper

Test Methods

Test Results

API Documentation

History

Introduction

API Category

Making API Requests

Instance APIs

Read-Only Instance APIs

Backup and Recovery APIs

Parameter Management APIs

Security Group APIs

Performance Optimization APIs

Account APIs

Specification APIs

Network APIs

Data Types

Error Codes

FAQs

Service Agreement

Service Level Agreement

Glossary

Database Management via Console

PDF

Modo Foco

Tamanho da Fonte

Última atualização: 2026-03-31 10:27:50

TencentDB for PostgreSQL supports managing databases in the console, as described below.
Creating a Database
Log in to the TencentDB for PostgreSQL Console, click Instance ID or the Operation column's Manage to enter the instance details page. Click Database Management > Database List > Create Database to create a database. The details are as follows:
Note:
The database name cannot be a system-reserved keyword. For specific keywords, refer to the official documentation.
﻿
﻿
Database List
Click Instance ID or the Operation column's Manage to enter the instance details page. Click Database Management to view the database list. The details are as follows:
﻿
Changing OWNER
Click Instance ID or the Operation column's Manage to enter the instance details page. Click Database Management to view the database list. In the Operation column, click Change Owner to modify the database owner. The details are as follows:
﻿
Delete Database
The current console does not support direct deletion of databases. If necessary, please click Delete in the Operation column. The system will automatically redirect you to the DMC management interface. Navigate to Database Management, then click Delete in the Operation column to complete the deletion process.
Note:
Deleting a database is a dangerous operation and may lead to data loss. Proceed with caution.
﻿
Description of Collation and Character Classification
In PostgreSQL, collation (mainly controlled by LC_COLLATE) and character classification (mainly controlled by LC_CTYPE) determine the sorting and comparison methods of string data as well as the classification attributes of characters. For detailed information on collation and character classification, refer to PostgreSQL’s official documentation on collation and locale.
Note:
Make sure consistent use of collation and character classification throughout the database to avoid inconsistencies in character processing behavior.