Question

How to change column type in PostgreSQL

Answer 1

ALTER TABLE table_name
ALTER COLUMN column_name TYPE new_data_type;


-- Example:

ALTER TABLE users
ALTER COLUMN full_name TYPE VARCHAR(255);

 

70+ SQL courses for beginners and professionals