Can be set for an individual connection or for PUBLIC. You must have the SET ANY PUBLIC OPTION system privilege to set this
option for PUBLIC or for another user or role.
Spatial values are fetched as character or binary because client libraries do not support spatial types directly. The st_geometry_describe_type
specifies how a geometry column or expression is described to the client. Many client applications use the describe type for
a column or expression to determine the client data type used to fetch the column or expression. Some client applications
ignore the describe type, so setting the st_geometry_describe_type may not have the desired effect.
If a geometry is fetched as a character string type, the st_geometry_astext_format option is used to determine how to convert
the geometry to text. If fetched as a binary type, the st_geometry_asbinary_format option is used. These are the same rules
used by a CAST statement.
In ODBC applications, the SQL_DESC_TYPE_NAME and SQL_DESC_LOCAL_TYPE_NAME field identifiers of SQLColAttribute return the
string st_geometry for columns of any geometry type. In JDBC, this is expressed by using the ResultSetMetaData.getColumnTypeName method.
Allowed values