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