Change data type for column in postgresql

To change the data type of column in table, use this:

ALTER TABLE channels ALTER COLUMN settings TYPE jsonb USING settings::jsonb;

 

Leave a Reply