PostgreSQL 修改字段属性

重命名

alter table record_page_view rename ua to user_agent; 

添加字段

alter table record_page_view add column ua2 text;

默认值

alter table record_page_view add column ua3 text default('this is default ua3'); 

删除字段

alter table record_page_view drop column ua2;

添加默认值

alter table record_page_view alter column ua set default 'this is default ua';

删除默认值

alter table record_page_view alter column ua drop default;

添加非空约束

alter table record_page_view alter column ua set not null;

删除非空约束

alter table record_page_view alter column ua drop not null;

添加主键

alter table record_page_view add primary key(ua);

添加注释

comment on column record_page_view.ua is '这是ua的注释';