ALTER TABLE schema.table ALTER COLUMN column DROP DEFAULT; ALTER TABLE schema.table ALTER COLUMN column TYPE INTEGER[] USING array[column]::INTEGER[]; ALTER TABLE schema.table ALTER COLUMN column SET DEFAULT '{}';