Good ideas and conversation. No ads, no tracking. Login or Take a Tour!
I'm learning/using PostGIS atm. It amazes me what can be done. Tangentially, I have a very very basic Postgres question: Can you query Postgres and just get the value(s) from a row without JSON or any other formatting? i.e. ..and if v1 is "foo", it only returns "foo". Not a table or JSON array with "foo" in it, etc. SELECT v1 FROM things WHERE id = 3;
That's mostly likely a function of whatever thing / programme you're using to query. Through PGAdmin or QGIS I also always get a table back. But I get values back when I query via Python: psycopg's fetch functions return just the data in a semi-structured fashion.