The data type of one or more columns in PostgreSQL can be changed by using the following commands along with the TYPE keyword:
ALTER TABLE
ALTER COLUMN
Example:
ALTER TABLE tab_name
ALTER COLUMN col_name TYPE new_data_type;