People's Congress Jincang database login, view database

Start database service test

​ 1. View the data storage directory

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

[[email protected] ~]$ cd /data/kingbase/v8/data/

[[email protected] data]$ ls -lh

Copy after login
[[email protected] 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
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               |       |p>

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