学习笔记-PGSQL常用的控制语句

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’)

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’);

comment on column t_cor_miner.image is ‘矿池小图’;

–删除默认值

ALTER TABLE 表名 ALTER COLUMN 字段名 DROP DEFAULT;

–添加默认值

ALTER TABLE 表名 ALTER COLUMN 字段名 SET DEFAULT 3;

–SQL不区分大小写模糊查询

ilike