pgsql -- 常用表结构修改

修改字段的字符串长度

alter table user alter column email type character varying(150);

删除不为空的约束

alter table user alter column age drop not null;

设置默认值

alter table user alter column age set default 10;

字段名重命名

alter table user rename name to username;
comment on column user.username is ‘用户名’;

添加字段

alter table user add column email character varying(25);
comment on column user.email is ‘邮箱’;

alter table user add column age integer not null default 10;
comment on column user.age is ‘年龄,默认10岁’;

删除字段

alter table user drop column email;

相关参考文章
pgsql常用命令