更新时间:2021-07-14 23:01:32
在PostgreSQL(和许多其他RDBMS),你可以使用 ALTER TABLE
语句:
On PostgreSQL (and many other RDBMS), you can do it with regular ALTER TABLE
statement:
essais=> SELECT * FROM Test1;
id | foo | bar
----+-----+-----
2 | 1 | 2
essais=> ALTER TABLE Test1 RENAME COLUMN foo TO baz;
ALTER TABLE
essais=> SELECT * FROM Test1;
id | baz | bar
----+-----+-----
2 | 1 | 2