[PostGIS] #5952: postgis.geometry_output_format GUC
PostGIS
trac at osgeo.org
Thu Jul 24 13:21:22 PDT 2025
#5952: postgis.geometry_output_format GUC
-------------------------+---------------------------
Reporter: pramsey | Owner: pramsey
Type: enhancement | Status: new
Priority: medium | Milestone: PostGIS 3.7.0
Component: postgis | Version: master
Keywords: |
-------------------------+---------------------------
Stolen from Snowflake, which has
{{{
ALTER SESSION SET GEOMETRY_OUTPUT_FORMAT='EWKT';
}}}
Would allow interactive SQL sessions to have WKT or GeoJSON outputs
instead of hex, without needing all that ST_As* wrapping on every call.
Only concern is GUC search overhead in the geometry_out handler, need to
validate if that overhead is acceptable (modern PgSQL versions have the
GUC values sorted and cached for fast lookup I think)
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5952>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-tickets
mailing list