kingbaseES基础 ksql 查看数据库列表

原创云散月明 All China Database Union 2022-07-11

2663

Server：CentOS 7.2.1511
KingbaseES：V8R6C5B23

\l+ 查看数据库列表

test=# \l
                                    数据库列表
   名称    | 拥有者 | 字元编码 |  校对规则   |    Ctype    |       存取权限       
-----------+--------+----------+-------------+-------------+----------------------
 security  | system | UTF8     | zh_CN.UTF-8 | zh_CN.UTF-8 | 
 template0 | system | UTF8     | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/system           +
           |        |          |             |             | system=CTc/system
 template1 | system | UTF8     | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/system           +
           |        |          |             |             | system=CTc/system
 test      | system | UTF8     | zh_CN.UTF-8 | zh_CN.UTF-8 | 
 test2     | system | UTF8     | zh_CN.UTF8  | zh_CN.UTF8  | =Tc/system          +
           |        |          |             |             | system=C*T*c*/system
(5 行记录)

test=# \l+
                                                                     数据库列表
   名称    | 拥有者 | 字元编码 |  校对规则   |    Ctype    |       存取权限       | 大小  |   表空间    |                  
  描述                    
-----------+--------+----------+-------------+-------------+----------------------+-------+-------------+------------------
--------------------------
 security  | system | UTF8     | zh_CN.UTF-8 | zh_CN.UTF-8 |                      | 13 MB | sys_default | 
 template0 | system | UTF8     | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/system           +| 12 MB | sys_default | unmodifiable empt
y database
           |        |          |             |             | system=CTc/system    |       |             | 
 template1 | system | UTF8     | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/system           +| 13 MB | sys_default | default template 
for new databases
           |        |          |             |             | system=CTc/system    |       |             | 
 test      | system | UTF8     | zh_CN.UTF-8 | zh_CN.UTF-8 |                      | 13 MB | sys_default | default administr
ative connection database
 test2     | system | UTF8     | zh_CN.UTF8  | zh_CN.UTF8  | =Tc/system          +| 13 MB | sys_default | 
           |        |          |             |             | system=C*T*c*/system |       |             | 
(5 行记录)