weixin_41908066的博客

1. postgresql删除字段，存在该字段才删除alter table [表名] drop column if exists [字段名];2.Postgresql批量删除/添加一张表的字段增加ALTER TABLE 【表名】 ADD COLUMN 【字段名】【数据类型】 【限制】, ADD COLUMN 【字段名】【数据类型】 【限制】;ALTER TABLE user ADD COLUMN user_name character varying not null, ADD CO

1.表字段查询sqlSELECT A.attnum AS "序号", C.relname AS "表名", A.attname AS "字段名",-- 字段名 t.typname as "字段类型", --字段类型 NULLIF(information_schema._pg_char_max_length(A.atttypid, A.atttypmod), -1) AS "字符串最大长度", -- 字符串最大长度 col_description ( A.attrelid, A.attn