postgresql的运用
使用pgAdmin4可视化工具来操作postgresql数据库
目录
1.创建/修改/删除数据库
create database book;
alter database book owner to postgres;
alter database book with connection limit = 10;
drop database book;
2.数据表的基本操作
2.1创建数据表
CREATE TABLE public."user"
(
id bigint NOT NULL,
username "char",
password "char",
phone integer,
email "char",
CONSTRAINT pri_key PRIMARY KEY (id),
CONSTRAINT name_only UNIQUE (username)
)
WITH (
OIDS = FALSE
)
TABLESPACE pg_default;
ALTER TABLE public."user"
OWNER to postgre