Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to copy data from pgAdmin without double quotes around the values

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.

like image 686
Rupesh Avatar asked Dec 05 '25 17:12

Rupesh


1 Answers

In File->Preferences, navigate to "Query Tool"->"Results grid" change the "Result copy quoting" dropdown to None

like image 146
Chris Amelinckx Avatar answered Dec 09 '25 03:12

Chris Amelinckx



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!