In this article, we will see the solution for ERROR: syntax error at or near “VARCHAR”.
Reolution: Continue reading PostgreSQL ERROR: syntax error at or near “VARCHAR”
Tag: datatype
How to change column datatype in PostgreSQL
In this article, we will see how to change column datatype in PostgreSQL. We can change the data type of a column by using the ALTER TABLE statement.
Two scenarios are there:
1. Change column datatype of table with data.
2. Change column datatype of table without data.
PostgreSQL change column data type statement:
To change the data type of a column, you use the ALTER TABLE statement as follows:
ALTER TABLE table_name ALTER [ COLUMN ] column_name [ SET DATA ] TYPE data_type [ COLLATE collation ] [ USING expression ]
Continue reading How to change column datatype in PostgreSQL