Updated on 2022-07-19 GMT+08:00

Checking Whether the Source Database Schema Name Is Valid

PostgreSQL

Table 1 Checking whether the source database schema name is valid

Check Item

Whether the source database schema name is valid

Description

The source database schema name cannot contain single quotation marks ('), double quotation marks ("), and periods (.). Ensure that the source database schema name does not contain invalid characters. Otherwise, the synchronization task fails.

Failure Cause and Handling Suggestion

Failure cause: The source database schema names contain unsupported characters.

Handling suggestion: Run the following command to change the source database schema names that contain unsupported characters:

alter schema old_name rename to new_name;