postgresql数据类型转换

alter table tbname alter column fieldname type date_type

--转换为date类型
alter table tbname alter column fieldname type date using cast(fieldname as date)

--转换为bool类型
ALTER TABLE tbname
ALTER COLUMN a TYPE boolean
USING CASE a
WHEN 'ano' THEN true
ELSE false END;