postgresql 创建表设置默认值
时间: 2023-10-01 20:07:58 浏览: 112
在PostgreSQL中,可以使用ALTER TABLE语句来为表设置默认值。例如,你可以使用以下语句在department表中添加一个名为"budget"的列,并将其默认值设置为130000:
ALTER TABLE department
ADD budget int DEFAULT 130000;
这将在department表中添加一个名为"budget"的整数类型列,并将默认值设置为130000。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *2* *3* [PostgreSQL基本操作二(新建表,插入数值,natural join,修改数值,添加列和默认值)](https://blog.csdn.net/weixin_39374967/article/details/102927436)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 100%"]
[ .reference_list ]