amazon-linux-extras install postgresql10 vim epel -y
yum install -y postgresql-server postgresql-devel
查看数据库,没有分号!!!
\l
进入数据库
use wuruan
创建表
CREATE TABLE Student(
ID INT PRIMARY KEY NOT NULL,
NAME TEXT NOT NULL
);
CREATE TABLE teacher(
ID INT PRIMARY KEY NOT NULL,
NAME TEXT NOT NULL
);
列出表
\d
插入值
insert into Student(id,name) values(1,‘zhangsan’);
详细参考文档
https://www.runoob.com/postgresql/postgresql-drop-database.html