ST_AsBinary function [Spatial]

The ST_AsBinary function returns a binary string representing the geometry. The output format is WKB as defined by OGC SFS 1.1. This format does not contain Z and M values.

Syntax

ST_AsBinary(geometry-expression)

Returns

Standards and compatibility

Example

The following returns the result 0x0101000000000000000000f03f0000000000000040.

select ST_AsBinary(ST_Point(1.0, 2.0, 4326))

The following returns the result 0x0101000000000000000000f03f0000000000000040. The server implicitly invokes the ST_AsBinary() function when converting geometries to BINARY.

select cast(ST_Point(1.0, 2.0, 4326) as binary(50))

Discuss this page in DocCommentXchange.