highgo=# \d test
table "public.test"
column | type | modifiers
--------+---------+------------
id | integer | default 15
no | integer |
highgo=# alter table test alter column id default 10;
错误: 语法错误 在 "default" 或附近的
line 1: alter table test alter column id default 10;
^
highgo=# alter table test alter column id set default 10;
alter table
highgo=# \d test
table "public.test"
column | type | modifiers
--------+---------+------------
id | integer | default 10
no | integer |
删除默认值:
highgo=# alter table test alter column id drop default;
alter table
highgo=#
highgo=# \d test
table "public.test"
column | type | modifiers
--------+---------+-----------
id | integer |
no | integer |
重新设置默认值:
highgo=# alter table test alter column id set default 10;
alter table
highgo=# \d test
table "public.test"
column | type | modifiers
--------+---------+------------
id | integer | default 10
no | integer |
如对本文有疑问, 点击进行留言回复!!
MongoDB安装和配置WINDOWS服务时1.x.x版本无serviceName的问题解决办法
MongoDB 概念理解、MongoDB shell 连接 Mongodb 服务
网友评论