How to change the datatype of a column in PostgreSQL?
To change the records type of a column, you use the ALTER TABLE assertion as follows:
BY Best Interview Question ON 17 Jun 2020
Example
ALTER TABLE users
ALTER COLUMN username[SET DATA] TYPE new_data_type;