要添加注释到表和列,我们可以使用PostgreSQL提供的ALTER TABLE语句。下面是示例代码:-- 创建表 CREATE TABLE students ( id SERIAL PRIMARY KEY, name VARCHAR(100) NOT NULL, age INT, address VARCHAR(200) ); -- 添加注释到表 COMMENT ON TABLE students IS 'This is a table for storing student ...
droptablet_hash;CREATETABLEt_hashASSELECTid,md5(id::text)md5_textFROMgenerate_series(1,500)ASid;SELECToidFROMpg_classWHERErelname='t_hash';selectoid,oid::regclass tbname,relname,reltuplesfrompg_classwhereoid='t_hash'::regclass;commentontablet_hashis'table t_hash';commentoncolumnt_hash.idis'...
create table test_c ( id integer PRIMARY KEY comment 'primary key', nick_name character varying(128) comment 'nick name' ); 1. 2. 3. 4. 5. 2.2 创建序列 CREATE SEQUENCE "public"."csdn_id_20200928_seq" INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 99999999 -- no maxvalue,没有最大值 C...
COMMENT ON COLUMN "public"."t_sys_log_main"."operation_value" IS '操作类型(value)'; COMMENT ON COLUMN "public"."t_sys_log_main"."operation_loginid" IS '操作帐号'; COMMENT ON COLUMN "public"."t_sys_log_main"."operation_message" IS '操作信息'; COMMENT ON COLUMN "public"."t_sys...
1 COMMENT ON TABLE "public"."tableName" IS '工资等级(绩效、薪资等)'; 4.创建表带有索引自增 1 CREATE TABLE "public"."tableName" (2 "id" serial PRIMARY KEY,3 "minvalue" float8,4 "maxvalue" float85 )6 ; 5.添加主键 1 ALTER TABLE "public"."tableName" ...
CREATE INDEX "IDX_OPT_FILE_TYPE_NO" ON public.opt_file_type USING btree (file_type_no COLLATE pg_catalog."default") INCLUDE(file_type_no, file_type) TABLESPACE pg_default; COMMENT ON INDEX public."IDX_OPT_FILE_TYPE_NO" IS '档案类型编码和名称创建索引';...
2.注意pgsql 的注释填写位置 并不是直接 在 字段后面添加 comment 比如 COMMENT ON TABLE sales_planning IS '存储公司销售计划的表'; 3.要有创建时间 create_time 修改时间 update_time 修改人 注意字段都是英文 4.字段名都用英文 5.注意 pgsql 的注释是不能写在 comment的 后面的...
COMMENT ON COLUMN "system_menu"."id" IS '菜单ID'; @@ -4239,7 +4239,7 @@ CREATE TABLE "system_notify_message" ( "template_content" varchar(1024) COLLATE "pg_catalog"."default" NOT NULL, "template_type" int4 NOT NULL, "template_params" varchar(255) COLLATE "pg_catalog"."default"...
COMMENT ON TABLE dataSet IS '格点数据集'; COMMENT ON column dataSet.id is '数据集id'; COMMENT ON column dataSet.start_x is '格网起点经度'; COMMENT ON column dataSet.start_y is '格网起点纬度'; COMMENT ON column dataSet.end_x is '格网终点经度'; ...
update_timestampTIMESTAMPDEFAULTCURRENT_TIMESTAMP,--修改时间,默认为当前时间戳 created_byVARCHAR(50)--创建人,存储创建者的用户名或标识);--添加表注释COMMENTONTABLEconf_dept_annual_kpi_import_exportIS'存储供应链进出口年度各个部门年度的基本考核指标';--添加字段注释COMMENTONCOLUMNconf_dept_annual_kpi_im...