-- Postgres alter varchar(4000) to TEXT -- mrequest ALTER TABLE mrequest ALTER COLUMN reason TYPE TEXT; ALTER TABLE mrequest ALTER COLUMN plandesc TYPE TEXT; ALTER TABLE mrequest ALTER COLUMN remark_wf TYPE TEXT; ALTER TABLE mrequest ALTER COLUMN responsibility TYPE TEXT; ALTER TABLE mrequest ALTER COLUMN destination TYPE TEXT; ALTER TABLE mrequest ALTER COLUMN conclusion TYPE TEXT; ALTER TABLE mrequest ALTER COLUMN language TYPE TEXT; ALTER TABLE mrequest ALTER COLUMN behavior TYPE TEXT; ALTER TABLE mrequest ALTER COLUMN position_specific TYPE TEXT; ALTER TABLE mrequest ALTER COLUMN orther_knowledge TYPE TEXT; ALTER TABLE mrequest ALTER COLUMN examdata TYPE TEXT; ALTER TABLE mrequest ALTER COLUMN pregnantdesc TYPE TEXT; ALTER TABLE mrequest ALTER COLUMN qualification TYPE TEXT; ALTER TABLE mrequest ALTER COLUMN software TYPE TEXT; ALTER TABLE mrequest ALTER COLUMN remark_hr TYPE TEXT; ALTER TABLE mrequest ALTER COLUMN other TYPE TEXT; ALTER TABLE mrequest ALTER COLUMN experience TYPE TEXT; ALTER TABLE mrequest ALTER COLUMN impairdesc TYPE TEXT; ALTER TABLE mrequest ALTER COLUMN cancel_reason TYPE TEXT; ALTER TABLE mrequest ALTER COLUMN router TYPE TEXT; -- mapplicant ALTER TABLE mapplicant ALTER COLUMN jobexp TYPE TEXT; ALTER TABLE mapplicant ALTER COLUMN education TYPE TEXT; ALTER TABLE mapplicant ALTER COLUMN contact TYPE TEXT; ALTER TABLE mapplicant ALTER COLUMN personal TYPE TEXT; ALTER TABLE mapplicant ALTER COLUMN skill TYPE TEXT; ALTER TABLE mapplicant ALTER COLUMN jobrouter TYPE TEXT; ALTER TABLE mapplicant ALTER COLUMN family TYPE TEXT; -- mappointment ALTER TABLE mappointment ALTER COLUMN detail TYPE TEXT; -- mjobrouter ALTER TABLE mjobrouter ALTER COLUMN jobrouter TYPE TEXT; -- mexam ALTER TABLE mexam ALTER COLUMN examdata TYPE TEXT; ALTER TABLE mexam ALTER COLUMN question TYPE TEXT; -- crecruit ALTER TABLE crecruit ALTER COLUMN object TYPE TEXT;