17.10 - Example: Exporting Geometry Data as CLOB in WKT Format - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Geospatial Data Types

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1181-171K
Language
English (United States)

Consider the following definition of a table that defines an ST_Geometry column for representing ST_Point values.

CREATE TABLE sample_points1 (skey INTEGER, point1 ST_Geometry);

By default, the following query issued through a client application results in the export of values in the point1 column using the WKT representation of a point:

SELECT *
FROM sample_points1;

SKEY          POINT1
--------      ------------
1001          POINT(10 20)

For more information on the WKT format of the ST_Geometry type, see Well-Known Text Format.