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.