SQL 如何更改 PostgreSQL 表中列的数据类型？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/7162903/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to alter a column's data type in a PostgreSQL table?
提问by kn3l
Entering the following command into a PostgreSQL interactive terminal results in an error:
在 PostgreSQL 交互式终端中输入以下命令会导致错误：
ALTER TABLE tbl_name ALTER COLUMN col_name varchar (11);
What is the correct command to alter the data type of a column?
更改列数据类型的正确命令是什么？
回答by Derek Kromm
See documentation here: http://www.postgresql.org/docs/current/interactive/sql-altertable.html
请参阅此处的文档：http: //www.postgresql.org/docs/current/interactive/sql-altertable.html
ALTER TABLE tbl_name ALTER COLUMN col_name TYPE varchar (11);
