启动数据库服务测试
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)
-----------------------------------