1.数据库实例A为大小写不敏感，先客户要求大小写敏感，—> 备份数据，新建实例，恢复数据

    1. [kingbase@centos7-vm ~]$ 
    2. [kingbase@centos7-vm ~]$ ksql -Usystem -W12345678ab TEST -f db_test.sql 
    3. SET
    4. SET
    5. SET
    6. SET
    7. SET
    8.    SET_CONFIG    
    9. -----------------
    10.  "$USER", PUBLIC
    11. (1 row)
    13. SET
    14. SET
    15. SET
    16. ksql:db_test.sql:22: 警告:  数据库 "test" 不存在
    17. COMMENT
    18. SET
    19. SET
    20. ksql:db_test.sql:37: 错误:  关系 "t001" 已经存在
    21. ksql:db_test.sql:40: 错误:  角色 "SYSTEM" 不存在
    22. ksql:db_test.sql:48: 错误:  关系 "t01" 已经存在
    23. ksql:db_test.sql:51: 错误:  角色 "SYSTEM" 不存在
    24. ksql:db_test.sql:57: 错误:  关系 "PUBLIC.pathman_config" 不存在
    25. ksql:db_test.sql:58: invalid command \.
    26. ksql:db_test.sql:65: 错误:  关系 "PUBLIC.pathman_config_params" 不存在
    27. ksql:db_test.sql:66: invalid command \.
    28. COPY 33000000
    29. COPY 0
    30. [kingbase@centos7-vm ~]$ ksql -Usystem -W12345678ab -dTEST
    31. ksql (V008R003C002B0242)
    32. Type "help" for help.
    34. TEST=# 
    35. TEST=# \l+         
    36.                                                                   List of databases
    37.    Name    | Owner  | Encoding |   Collate   |    Ctype    | Access privileges  |  Size   | Tablespace  |                Description 
    39. -----------+--------+----------+-------------+-------------+--------------------+---------+-------------+----------------------------
    40. ----------------
    41.  SAMPLES   | system | UTF8     | zh_CN.UTF-8 | zh_CN.UTF-8 |                    | 13 MB   | SYS_DEFAULT | 
    42.  SECURITY  | system | UTF8     | zh_CN.UTF-8 | zh_CN.UTF-8 |                    | 11 MB   | SYS_DEFAULT | 
    43.  TEMPLATE0 | system | UTF8     | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/system         +| 11 MB   | SYS_DEFAULT | unmodifiable empty database
    44.            |        |          |             |             | system=CTcb/system |         |             | 
    45.  TEMPLATE1 | system | UTF8     | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/system         +| 11 MB   | SYS_DEFAULT | default template for new da
    46. tabases
    47.            |        |          |             |             | system=CTcb/system |         |             | 
    48.  TEMPLATE2 | system | UTF8     | zh_CN.UTF-8 | zh_CN.UTF-8 | =Tc/system        +| 11 MB   | SYS_DEFAULT | 
    49.            |        |          |             |             | system=CTcb/system |         |             | 
    50.  TEST      | system | UTF8     | zh_CN.UTF-8 | zh_CN.UTF-8 |                    | 2835 MB | SYS_DEFAULT | default administrative conn
    51. ection database
    52. (6 rows)
    54. TEST=# select count(*) from t001;
    55. 错误:  关系 "T001" 不存在
    56. LINE 1: select count(*) from t001;
    57.                              ^
    58. TEST=# 
    59. TEST=# select count(*) from T001;
    60. 错误:  关系 "T001" 不存在
    61. LINE 1: select count(*) from T001;
    62.                              ^
    63. TEST=# 
    64. TEST=# 
    65. TEST=# \dt
    66.                 List of relations
    67.  Schema |         Name          | Type  | Owner  
    68. --------+-----------------------+-------+--------
    69.  PUBLIC | PATHMAN_CONFIG        | table | system
    70.  PUBLIC | PATHMAN_CONFIG_PARAMS | table | system
    71.  PUBLIC | t001                  | table | system
    72.  PUBLIC | t01                   | table | system
    73. (4 rows)
    75. TEST=# 
    76. TEST=# select count(*) from t001;
    77. 错误:  关系 "T001" 不存在
    78. LINE 1: select count(*) from t001;
    79.                              ^
    80. TEST=# 
    81. TEST=# \dn
    82.        List of schemas
    83.         Name        | Owner  
    84. --------------------+--------
    85.  INFORMATION_SCHEMA | system
    86.  PUBLIC             | system
    87.  SYSAUDIT           | system
    88.  SYSLOGICAL         | system
    89.  XLOG_RECORD_READ   | system
    90. (5 rows)
    92. TEST=# \dn+
    93.                              List of schemas
    94.         Name        | Owner  | Access privileges |      Description       
    95. --------------------+--------+-------------------+------------------------
    96.  INFORMATION_SCHEMA | system | system=UC/system +| 
    97.                     |        | =U/system         | 
    98.  PUBLIC             | system | system=UC/system +| standard public schema
    99.                     |        | =UC/system        | 
    100.  SYSAUDIT           | system | system=UC/system +| 
    101.                     |        | SYSSSO=UC/system +| 
    102.                     |        | SYSSAO=UC/system +| 
    103.                     |        | =UC/system        | 
    104.  SYSLOGICAL         | system | system=UC/system +| 
    105.                     |        | =U/system         | 
    106.  XLOG_RECORD_READ   | system |                   | 
    107. (5 rows)
    109. TEST=# 
    110. TEST=# \dt+
    111.                              List of relations
    112.  Schema |         Name          | Type  | Owner  |    Size    | Description 
    113. --------+-----------------------+-------+--------+------------+-------------
    114.  PUBLIC | PATHMAN_CONFIG        | table | system | 8192 bytes | 
    115.  PUBLIC | PATHMAN_CONFIG_PARAMS | table | system | 8192 bytes | 
    116.  PUBLIC | t001                  | table | system | 2825 MB    | 
    117.  PUBLIC | t01                   | table | system | 0 bytes    | 
    118. (4 rows)
    120. TEST=# select count(*) from PUBLIC.t001
    121. TEST-# ;
    122. 错误:  关系 "PUBLIC.T001" 不存在
    123. LINE 1: select count(*) from PUBLIC.t001
    124.                              ^
    125. TEST=# 
    126. TEST=# select count(*) from "PUBLIC.T001"; 
    127. 错误:  关系 "PUBLIC.T001" 不存在
    128. LINE 1: select count(*) from "PUBLIC.T001";
    129.                              ^
    130. TEST=# select count(*) from "PUBLIC.T001";
    131. 错误:  关系 "PUBLIC.T001" 不存在
    132. LINE 1: select count(*) from "PUBLIC.T001";
    133.                              ^
    134. TEST=# 
    135. TEST=# select count(*) from public.t001;
    136. 错误:  关系 "PUBLIC.T001" 不存在
    137. LINE 1: select count(*) from public.t001;
    138.                              ^
    139. TEST=# select count(*) from "PUBLIC"."t001";
    140.   COUNT   
    141. ----------
    142.  33000000
    143. (1 row)
    145. TEST=# show case_sensitive ;
    146.  case_sensitive 
    147. ----------------
    148.  on
    149. (1 row)
    151. TEST=#

    自动转大写

    大小写敏感双引号