postgresql建表带注释_使用PostgreSQL为表或视图创建备注的操作

1 为表和列创建备注

drop table if exists test;

create table test(

objectid serial not null,

num integer not null,

constraint pk_test_objectid primary key (objectid),

constraint ck_test_num check(num < 123 ),

);

comment on table test is '我是表';

comment on column test.objectid is '我是唯一主键';

comment on column test.num is '数量字段';

comment on constraint pk_test_objectid on test is '我是约束,唯一主键';

comment on constraint ck_test_num on test is '我是约束,num字段必须小于123';

\dS+ test;

2 为视图和列创建备注

drop view if exists vtest;

create or replace view vtest

as select 1 as col1, 'a' as col2, now() as col3;

comment on view vtest is '视图备注';

comment on column vtest.col1 is '第一列备注,integer类型';

comment on column vtest.col2 is '第二列备注,字符类型';