tencent cloud

Feedback

Database Management via Console

Last updated: 2024-10-28 14:59:08
    TencentDB for PostgreSQL supports managing databases in the console, as described below.

    Creating a Database

    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:
    

    Deletion

    The current console does not support database deletion. If you need to delete a database, click Delete in the Operation column. The system will automatically redirect you to the DMC management interface for SQL deletion.
    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.
    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support