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