I have the below query to convert geometry into GeoJSON format.
select ST_ASGEOJSON(POLYGON_GEOMETRY) from "POC"."POLYGON_PLN";
output:
{"type":"Polygon","coordinates":[[[10.3986007,47.95355213],[10.39885819,47.95386829],[10.39924443,47.95400241],[10.39955914,47.95422277],[10.39967358,47.95436647][10.3986007,47.95355213]]]}
The output is fine, But when I tried to copy the output within pgAdmin 4 (or) when I refer this output for some other thing, I am getting the quotations at beginning and end.
Please suggest a way to remove these quotations.
In File->Preferences, navigate to "Query Tool"->"Results grid" change the "Result copy quoting" dropdown to None
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With