PostGIS

ST_AsHexWKB

Prev

12.11. Raster Outputs

Next

Name

ST_AsHexWKB — Return the Well-Known Binary (WKB) in Hex representation of the raster.

Synopsis

bytea +`*`+ST_AsHexWKB*(`raster `rast, boolean outasin=FALSE`)`;

Description

Returns the Binary representation in Hex representation of the raster. If outasin is TRUE, out-db bands are treated as in-db. Refer to raster/doc/RFC2-WellKnownBinaryFormat located in the PostGIS source folder for details of the representation.

Note

By default, Hex WKB output contains the external file path for out-db bands. If the client does not have access to the raster file underlying an out-db band, set outasin to TRUE.

Availability: 2.5.0

Examples

SELECT ST_AsHexWKB(rast) As rastbin FROM dummy_rast WHERE rid=1;

                                                        st_ashexwkb
----------------------------------------------------------------------------------------------------------------------------
 010000000000000000000000400000000000000840000000000000E03F000000000000E03F000000000000000000000000000000000A0000000A001400

See Also

ST_RastFromHexWKB, ST_AsBinary/ST_AsWKB

Prev

Up

Next

ST_AsBinary/ST_AsWKB

Home

ST_AsGDALRaster