HGDB表中修改默认值的方法

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 |