ALTER TABLE "newWorldCountries" ALTER COLUMN "isoCode" TYPE text , ALTER COLUMN "isNewWorld" DROP DEFAULT , ALTER COLUMN "isNewWorld" TYPE boolean USING "isNewWorld"::boolean , ALTER COLUMN "countryNameStd" TYPE text ; ALTER TABLE "newWorldCountries" ADD UNIQUE ("countryNameStd"); ALTER TABLE "newWorldCountries" ADD UNIQUE ("isoCode");