st_geometry_astext_format option

Controls how spatial values are converted from a geometry to text.

Allowed values

The list of values supported for this option is identical to the list of parameters (including sub-parameters) documented for the ST_AsText method.

Default

WKT

Scope

	PUBLIC role	For current user	For other users
Allowed to set permanently?	Yes, with SET ANY PUBLIC OPTION	Yes	Yes, with SET ANY PUBLIC OPTION
Allowed to set temporarily?	Yes, with SET ANY PUBLIC OPTION	Yes (current connection only)	No

Remarks

This option is used to determine how a geometry is converted to text. The following are the two main contexts in which the option is used:

fetching a value as text from a client application
Executing a CAST statement. For example: CAST( geometry-expression AS LONG VARCHAR )

Assignments from geometry types to CHAR types give an error in contexts other than fetching from a client application and the CAST statement. For example, you cannot call a function or procedure that takes a CHAR parameter and pass a geometry, nor can you assign a geometry to a LONG VARCHAR variable.