17.10 - Create Table and Insert Syntax - Geospatial Utilities

Teradata® Geospatial Utilities User Guide

Product
Geospatial Utilities
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-07-01
dita:mapPath
ngj1608578450889.ditamap
dita:ditavalPath
obe1474387269547.ditaval

Create table and insert syntax (POINT type data into ST_Geometry column):

CREATE TABLE customers(pkey integer, cust_name VARCHAR(10),cust_zipcode VARCHAR(5) , loc ST_Geometry);
INSERT INTO customers(0, 'Fred Smith', '91234', new ST_Geometry('POINT(20.34 80.78)'));
INSERT INTO customers(1, 'Richard Connor', '95421', new ST_Geometry('POINT(20.56 89.44)'));
INSERT INTO customers(2, 'Anita Johnson', '98523', new ST_Geometry('POINT(19.12 88.22)'));
INSERT INTO customers(3, 'Mary Willow', '90642', new ST_Geometry('POINT(21.45 88.12)'));

The following figure shows create table and insert syntax (POINT type data into ST_Geometry column).

Create Table and Insert Syntax USING BTEQ Example

The following figure shows the retrieved data table.

Retrieved Data Table Using BTEQ Example