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 varchar_tab1 (a int, b VARCHAR (60000));
INSERT INTO varchar_tab1 VALUES (1001, 'Point(10 20 30)');
CREATE TABLE sample_shapes(skey INTEGER, shape ST_Geometry);
INSERT INTO sample_shapes
SELECT a, SYSSPATIAL.ST_GeomFromText(b) FROM varchar_tab1;
SELECT * FROM sample_shapes;