Changes between Version 57 and Version 58 of InstallationGuidelines/PostgreSQL


Ignore:
Timestamp:
01/22/12 11:02:12 (13 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • InstallationGuidelines/PostgreSQL

    v57 v58  
    162162UPDATE public.gis_location SET wkt = 'POINT (' || lon || ' ' || lat || ')' WHERE gis_feature_type = 1;
    163163SELECT AddGeometryColumn( 'public', 'gis_location', 'the_geom', 4326, 'GEOMETRY', 2 );
     164GRANT ALL ON geometry_columns TO sahana;
    164165UPDATE public.gis_location SET the_geom = ST_SetSRID(ST_GeomFromText(wkt), 4326);
    165166EOF