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 |