Changes between Version 17 and Version 18 of InstallationGuidelines/Linux/Server/CherokeePostgreSQL
- Timestamp:
- 01/22/12 11:03:54 (13 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
InstallationGuidelines/Linux/Server/CherokeePostgreSQL
v17 v18 543 543 UPDATE public.gis_location SET wkt = 'POINT (' || lon || ' ' || lat || ')' WHERE gis_feature_type = 1; 544 544 SELECT AddGeometryColumn( 'public', 'gis_location', 'the_geom', 4326, 'GEOMETRY', 2 ); 545 GRANT ALL ON geometry_columns TO sahana; 545 546 UPDATE public.gis_location SET the_geom = ST_SetSRID(ST_GeomFromText(wkt), 4326); 546 547 EOF