【我和openGauss的故事】openGauss初体验

su - omm
1.

gs_om -t start
1.

gsql -d postgres -p 26000
1.

postgres=# alter role omm identified by 'Bigdata@123' replace 'openGauss@123';
ALTER ROLE
1.
2.

CREATE USER tom WITH PASSWORD "Tom12345";
1.

postgres=# \du
1.

CREATE DATABASE
1.

postgres=# \q
1.

[omm@localhost ~]$ gsql -d dbdemo -p 26000 -U tom -W Tom12345 
1.

dbdemo=> CREATE SCHEMA tom AUTHORIZATION tom;
1.

CREATE TABLE USER1
(
Uid VARCHAR2(15)PRIMARY KEY ,
Uname VARCHAR2(18),
Uage INT,
Usex VARCHAR2(3) ,
Uweight INT,
Uhight INT
);
1.
2.
3.
4.
5.
6.
7.
8.
9.

dbdemo=> \d
1.

INSERT INTO USER1(Uid, Uname, Uage, Usex, Uweight, Uhight) VALUES ('123456', '张三', '19', '男', '55',182);
INSERT INTO USER1(Uid, Uname, Uage, Usex, Uweight, Uhight) VALUES ('123455', '李四', '22', '女', '48',165);
1.
2.

dbdemo=> SELECT * FROM
1.

dbdemo=> UPDATE USER1 SET Uage=20 WHERE Uname='张三';
UPDATE 1
dbdemo=> SELECT * FROM
1.
2.
3.

dbdemo=> DELETE FROM USER1 WHERE Uname='李四';
DELETE 1
dbdemo=> SELECT * FROM USER1;
1.
2.
3.