ST_Geometry constructs a geometry from a well-known text representation.
Oracle
sde.st_geometry (wkt clob, srid integer)
PostgreSQL
st_geometry (wkt, srid integer)
st_geometry (esri_shape bytea, srid integer)
Create a table, geoms, and insert values into it.
Oracle
CREATE TABLE geoms (id integer, geometry sde.st_geometry);
INSERT INTO geoms (id, geometry) VALUES (
1901,
sde.st_geometry ('point (1 2)', 0)
);
INSERT INTO geoms (id, geometry) VALUES (
1902,
sde.st_geometry ('linestring (33 2, 34 3, 35 6)', 0)
);
INSERT INTO geoms (id, geometry) VALUES (
1903,
sde.st_geometry ('polygon ((3 3, 4 6, 5 3, 3 3))', 0)
);
PostgreSQL
CREATE TABLE geoms (id integer, geometry st_geometry);
INSERT INTO geoms (id, geometry) VALUES (
1901,
st_geometry ('point (1 2)', 0)
);
INSERT INTO geoms (id, geometry) VALUES (
1902,
st_geometry ('linestring (33 2, 34 3, 35 6)', 0)
);
INSERT INTO geoms (id, geometry) VALUES (
1903,
st_geometry ('polygon ((3 3, 4 6, 5 3, 3 3))', 0)
);
Select the geometry from the geoms table.
Oracle
SELECT id, sde.st_astext (geometry) geometry
FROM geoms;
ID GEOMETRY
1901 POINT (1.00000000 2.00000000)
1902 LINESTRING (33.00000000 2.00000000, 34.00000000 3.00000000, 35.00000000 6.00000000)
1903 POLYGON ((3.00000000 3.00000001, 5.00000000 3.00000000, 4.00000000 6.00000000, 3.00000000 3.00000000))
PostgreSQL
SELECT id, st_astext (geometry) AS geometry
FROM geoms;
id geometry
1901 POINT (1 2)
1902 LINESTRING (33 2, 34 3, 35 6)
1903 POLYGON ((3 3, 5 3, 4 6, 3 3))