pg命令汇总

 

创建非空约束

create database test with template = template0 encoding='UTF8' lc_collate='C' lc_ctype='C';

\c test

create table tbl_null (a int not null,b varchar(12));

insert into tbl_null (a,b) values(1,'1');

insert into tbl_null (a) values(2);

insert into tbl_null (b) values('3');

select * from tbl_null;