[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