Example

Teradata Vantage™ Geospatial Data Types

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1181-162K
CREATE TABLE varbyte_tab1 (a int, b VARBYTE (6000));
INSERT INTO varbyte_tab1 VALUES (1002, NEW ST_Geometry(
 'Point(10 20 30)').ST_Asbinary());
INSERT INTO sample_shapes
SELECT a, SYSSPATIAL.ST_GeomFromWKB(b) FROM varbyte_tab1;
SELECT * FROM sample_shapes;