Changes between Version 57 and Version 58 of InstallationGuidelines/PostgreSQL
- Timestamp:
- 01/22/12 11:02:12 (13 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
InstallationGuidelines/PostgreSQL
v57 v58 162 162 UPDATE public.gis_location SET wkt = 'POINT (' || lon || ' ' || lat || ')' WHERE gis_feature_type = 1; 163 163 SELECT AddGeometryColumn( 'public', 'gis_location', 'the_geom', 4326, 'GEOMETRY', 2 ); 164 GRANT ALL ON geometry_columns TO sahana; 164 165 UPDATE public.gis_location SET the_geom = ST_SetSRID(ST_GeomFromText(wkt), 4326); 165 166 EOF