GreenPlum数据库及语法使用

1.启动和停止

su gpadmin

gpstart -a(-a的原因是不需要在手动输入yes)

gpstop -a

2.查看数据库状态

psql -l

pgstate

3.命令行连接访问数据库

4.DML操作

• 创建新表

create table user(
	name varchar(20),
    signup_date DATE
);

insert into 
user(name,sing_date) values('张三','2021-10-21');

select * 
from user;

update user set name = 'zxy' where name = 'zhou';

delete from user where name = '李四';

alter table user add email varchar(40);

alter table user alter column sing_date set not null;

alter table user rename column sing_date to signup;

alter table user drop column email;

drop table if exists user;

createdb serviceDB(库名) -E utf-8
然后默认数据库
export GPDATABASE = serviceDB
进入命令界面
psql

-- 方法一
create user as select * from text1;

--方法二
select * into user from text1;