人大金仓数据库登录、查看数据库

启动数据库服务测试

​ 1、查看数据存储目录

[root@node1 ~]# su - kingbase
Last login: Mon Mar  1 18:00:48 CST 2021 on pts/2

[kingbase@node1 ~]$ cd /data/kingbase/v8/data/

[kingbase@node1 data]$ ls -lh
 

登录后复制 
[kingbase@node1 bin]$ ./ksql -U system -W test
Password: 
ksql (V8.0)
Type "help" for help.

test=# \l
                               List of databases
   Name    | Owner  | Encoding |   Collate   |    Ctype    | Access privileges 
-----------+--------+----------+-------------+-------------+-------------------
 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 | 
(4 rows)

test=# create database prod;
CREATE DATABASE
test=# \c prod
Password: 
You are now connected to database "prod" as user "system".
prod=# create table t1 (id int,name varchar(10));
CREATE TABLE
prod=# \d t1
                          Table "public.t1"
 Column |            Type            | Collation | Nullable | Default 
--------+----------------------------+-----------+----------+---------
 id     | integer                    |           |          | 
 name   | character varying(10 char) |           |          | 

prod=# insert into t1 values (10,'tom'),(20,'jerry'),(30,'rose');
INSERT 0 3
prod=# select * from t1;
 id | name  
----+-------
 10 | tom
 20 | jerry
 30 | rose
(3 rows)
-----------------------------------