/** 更改数据类型 /
ALTER TABLE t_cor_miner ALTER COLUMN chinese_icture TYPE text;
ALTER TABLE t_cor_miner ALTER COLUMN english_icture TYPE text;
/* 修改字段类型为int */
alter table t_cor_miner_recording alter COLUMN total type int4 using total::int4;
/** 更改字段名称 */
ALTER TABLE t_cor_miner RENAME chinese_icture TO chinese_picture
ALTER TABLE t_cor_miner RENAME english_icture TO english_picture;
/** 增加字段 */
alter table t_cor_miner add chinese_icture VARCHAR(225)
alter table t_cor_miner add english_icture VARCHAR(225)
/** 替换字符串 */
update t_cms_notice set content=replace(content,‘184’,‘212’)
/** ID自增长 */
CREATE SEQUENCE financial_record_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
alter table financial_record alter column id set default nextval(‘financial_record_id_seq’);
/** 删除主键自增 /
DROP SEQUENCE trans_id_seq;
/* 字段注释 */
comment on column t_cor_miner.image is ‘矿池小图’;
–删除默认值
ALTER TABLE 表名 ALTER COLUMN 字段名 DROP DEFAULT;
–添加默认值
ALTER TABLE 表名 ALTER COLUMN 字段名 SET DEFAULT 3;
–SQL不区分大小写模糊查询
ilike