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;

Suggest An Answer

Our Particitants

In the Unix environment, first, connect the PostgreSQL server and write below example syntax:\c database name. ex:\c template1.