CREATE TABLE sample_streets( skey INTEGER, streetName VARCHAR(40), streetShape ST_GEOMETRY); INSERT INTO sample_streets VALUES(1, 'Main Street', 'LINESTRING(2 2, 3 2, 4 1)'); INSERT INTO sample_streets VALUES(1, 'Coast Blvd', 'LINESTRING(12 12, 18 17)'); SELECT streetShape.ST_AsText() FROM sample_streets WHERE skey < 1001;