To change the data type of column in table, use this:
ALTER TABLE channels ALTER COLUMN settings TYPE jsonb USING settings::jsonb;
– Senior Fullstack Web Engineer
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
You must be logged in to post a comment.