配置环境变量

    新建数据库，特定属主、指定编码格式

    1. create database db1 with owner = "system" encoding UTF8 template template0;

    新建模式，指定属主

    1. create schema sc1 authorization "system";
    1. [kingbase@centos7-vm ~]$ 
    2. [kingbase@centos7-vm ~]$ ksql -USYSTEM -W12345678ab -dTEST
    3. ksql: 致命错误:  用户 "SYSTEM" Password 认证失败
    4. [kingbase@centos7-vm ~]$ 
    5. [kingbase@centos7-vm ~]$ ksql -Usystem -W12345678ab -dTEST
    6. ksql (V008R003C002B0242)
    7. Type "help" for help.
    9. TEST=#

    表空间

    1. [kingbase@centos7-vm ~]$ ksql -Usystem -W12345678ab -dTEST
    2. ksql (V008R003C002B0242)
    3. Type "help" for help.
    5. TEST=# create tablespace tbs location '/home/kingbase/tbs';
    6. CREATE TABLESPACE
    7. TEST=# 
    8. TEST=# create database mydb t
    9. tablespace  template    
    10. TEST=# create database mydb tablespace tbs;
    11. CREATE DATABASE
    12. TEST=# 
    13. TEST=# 
    14. TEST=# create table t0001(id int) tablespace tbs;
    15. CREATE TABLE
    16. TEST=#