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

启动数据库服务测试

? 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)
-----------------------------------
?