Changes between Version 16 and Version 17 of InstallationGuidelines/Linux/Server/CherokeePostgreSQL
- Timestamp:
- 01/22/12 11:03:21 (13 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
InstallationGuidelines/Linux/Server/CherokeePostgreSQL
v16 v17 400 400 UPDATE public.gis_location SET wkt = 'POINT (' || lon || ' ' || lat || ')' WHERE gis_feature_type = 1; 401 401 SELECT AddGeometryColumn( 'public', 'gis_location', 'the_geom', 4326, 'GEOMETRY', 2 ); 402 GRANT ALL ON geometry_columns TO sahana; 402 403 UPDATE public.gis_location SET the_geom = ST_SetSRID(ST_GeomFromText(wkt), 4326); 403 404 EOF