PostgreSql常用脚本

添加表字段

ALTER TABLE public.university ADD COLUMN "Province" character varying(10); COMMENT ON COLUMN public.university."Province" IS '省份';

删除表字段

ALTER TABLE public.university DROP COLUMN "Province"

　　

 

转载于:https://www.cnblogs.com/Fly-sky/p/5417215.html