Description

In apsaradb for PostgreSQL, run the following SQL statement to modify uppercase table names:

alter table blacklist rename to BLACKLIST
The system displays an error similar to the following.
ERROR: relation "blacklist" already exists

 

Causes

By default, PostgreSQL is not case sensitive.

 

Solutions

Alibaba Cloud reminds you that:

  • When you perform operations that have risks, such as modifying instance configurations or data, check the disaster recovery and fault tolerance capabilities of the instances to ensure data security.
  • Before you modify the configurations and data of instances including but not limited to ECS and RDS instances, we recommend that you create snapshots or enable RDS log backup.
  • If you have authorized or submitted security information such as the logon account and password in the Alibaba Cloud Management console, we recommend that you modify such information in a timely manner.
You need to enclose uppercase table names with double quotation marks (""). An example of the SQL statement is as follows:
alter table blacklist rename "BLACKLIST";
Instructions table names must be in uppercase for subsequent queries.
 

Application scope

  • ApsaraDB RDS for PostgreSQL

 

If the problem persists, you can receive a free consultation in Alibaba Cloud Community or submit a ticket to contact Alibaba Cloud technical support personnel.