ST_GeogFromWKB

This section contains reference documentation for the ST_GeogFromWKB function.

Returns a geography type object from WKB representation.

Signature

ST_GeogFromWKB(wkb)

Usage Examples

select STPOINT(-122, 37) AS point,
       ST_GeogFromWKB(
         ST_AsBinary(STPOINT(-122, 37))
       ) AS value
from ignoreMe 
pointvalue

00c05e8000000000004042800000000000

80c05e8000000000004042800000000000

select STPOINT(-122, 37, 1) AS point,
       ST_GeogFromWKB(
         ST_AsBinary(STPOINT(-122, 37, 1))
       ) AS value
from ignoreMe 
pointvalue

80c05e8000000000004042800000000000

80c05e8000000000004042800000000000

You can create geometry objects in the WKB format using the ST_AsBinary function.