查看代码
SELECTrow_to_json(fc)
FROM (SELECT'FeatureCollection' AS type, array_to_json(array_agg(f)) AS featuresFROM (SELECT'Feature' AS type, ST_AsGeoJSON(geom)::json as geometry , (SELECTrow_to_json(t)FROM (SELECTid, user,content) AS t) AS propertiesFROM test_table ) AS f
) AS fc