修改字段的字符串长度
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常用命令
2833



被折叠的 条评论
为什么被折叠?



