postgresql查询返回jsonArray
select array_to_json(array_agg(row_to_json(t.*))) as json_obj from cwcode.cwcode_platform t
select row_to_json(t.*) from cwcode.cwcode_platform T limit 1
空间坐标转geojson
SELECT
row_to_json (bb)
FROM
(
SELECT
'FeatureCollection' AS TYPE,
array_to_json ( ARRAY_AGG ( aa ) ) AS features
FROM
(
SELECT
'feature' AS TYPE,
ST_AsGeoJSON ( positioning_coordinates ) :: json AS geometry,
( SELECT row_to_json ( D ) FROM ( SELECT '要查询的字段,逗号分割' ) AS D ) AS properties
FROM
dailymaintenance.maintenance_facility_record
) AS aa
) AS bb