KMLWrite
Signature
KMLWrite(VARCHAR path, VARCHAR tableName);Description
Writes table tableName to a KML file located at path.
A coordinate reference system must be set to save a KML file.
Examples
-- Create an example table to write to a KML file:
CREATE TABLE TEST(ID INT PRIMARY KEY, THE_GEOM POINT);
INSERT INTO TEST
VALUES (1, ST_GeomFromText('POINT(2.19 47.58)', 4326));
-- Write it:
CALL KMLWrite('/home/user/test.kml', 'TEST');