SELECT split_part(entername, '~', 1) AS entname
, split_part(entername, '~', 2) AS entcode
, split_part(entername, '~', 3) AS outcode
, split_part(entername, '~', 4)::timestamp AS time,
"001" AS ph,
"011" AS cod,
"060" AS an,
"101" AS tp,
"b01" AS flow
FROM crosstab(
'select entname || ''''~'''' || entcode|| ''''~'''' ||outcode|| ''''~'''' ||time,type,value from busi_data_water_pollution',
'select distinct type from busi_data_water_pollution')
("entername" text,
"001" text,
"011" text,
"060" text,
"101" text,
"b01" text);
项目中用到了该SQL记录一下!