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


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

--

Legend:

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

    v16 v17  
    400400UPDATE public.gis_location SET wkt = 'POINT (' || lon || ' ' || lat || ')' WHERE gis_feature_type = 1;
    401401SELECT AddGeometryColumn( 'public', 'gis_location', 'the_geom', 4326, 'GEOMETRY', 2 );
     402GRANT ALL ON geometry_columns TO sahana;
    402403UPDATE public.gis_location SET the_geom = ST_SetSRID(ST_GeomFromText(wkt), 4326);
    403404EOF