删除 PostgreSQL 表的列
确认栏位名称
SELECT *
FROM TableName
删除列
ALTER TABLE "TableName" DROP COLUMN "columnName";
增加列
ALTER TABLE "TableName" ADD COLUMN "columnName" DataType;
// ALTER TABLE "TableName" ADD COLUMN "columnName" INTEGER;
SELECT *
FROM TableName
ALTER TABLE "TableName" DROP COLUMN "columnName";
ALTER TABLE "TableName" ADD COLUMN "columnName" DataType;
// ALTER TABLE "TableName" ADD COLUMN "columnName" INTEGER;