Changes between Version 17 and Version 18 of InstallationGuidelines/Linux/Server/CherokeePostgreSQL


Ignore:
Timestamp:
01/22/12 11:03:54 (10 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • InstallationGuidelines/Linux/Server/CherokeePostgreSQL

    v17 v18  
    543543UPDATE public.gis_location SET wkt = 'POINT (' || lon || ' ' || lat || ')' WHERE gis_feature_type = 1;
    544544SELECT AddGeometryColumn( 'public', 'gis_location', 'the_geom', 4326, 'GEOMETRY', 2 );
     545GRANT ALL ON geometry_columns TO sahana;
    545546UPDATE public.gis_location SET the_geom = ST_SetSRID(ST_GeomFromText(wkt), 4326);
    546547EOF