postgrest icon indicating copy to clipboard operation
postgrest copied to clipboard

Published 20 hours ago • verified publisher icon PostgREST

PostGIS geometry returned as binary in text/csv output when WKT would be expected

Open bjornharrtell opened this issue 1 year ago • 3 comments

Environment

  • PostgreSQL version: 12
  • PostgREST version: postgrest/postgrest:v12.0.2
  • Operating system:

Description of issue

PostGIS geometry is returned as some kind of binary string encoding when client has requested text/csv output. In standard json output it is GeoJSON which is logical and expected. In text/csv I would expect WKT representation (see https://postgis.net/docs/manual-3.4/ST_AsText.html).

bjornharrtell avatar Jun 09 '24 17:06 bjornharrtell