15.10 - ST_AsBinary - Teradata Database

Teradata Database SQL Geospatial Types

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1181-151K

Returns the well-known binary (WKB) representation of an ST_Geometry value.

Returns a BLOB value.

The maximum size of the return value is 16 MB (the exact maximum is 16 MB ‑ 1 KB).

For details on WKB formats, see “Well-Known Binary Representation” on page 198.

All ST_Geometry types.

   CREATE TABLE blob_table (bkey INTEGER, b1 blob);   
   INSERT INTO blob_table
   SELECT skey, shape.ST_AsBinary()
   FROM sample_shapes
   WHERE skey < 1009;