How to change the datatype of a column in PostgreSQL?

1.	How to change the datatype of a column in PostgreSQL?
Answer» To change the records TYPE of a column, you USE the ALTER TABLE ASSERTION as FOLLOWS: Example ALTER TABLE users ALTER COLUMN username[SET DATA] TYPE new_data_type;

Answer»

To change the records TYPE of a column, you USE the ALTER TABLE ASSERTION as FOLLOWS:

Example

ALTER TABLE users
ALTER COLUMN username[SET DATA] TYPE new_data_type;

Discussion