PostGIS中生成GUID字段值

create extension "uuid-ossp"

update base_region set region_id = uuid_generate_v4()

update base_region set region_id = upper( replace(region_id,'-',''))