[postgis-devel] Geometry Columns View

maplabs at light42.com maplabs at light42.com
Sun Oct 23 10:33:44 PDT 2011



On Tue, 18 Oct 2011 10:23:06 +0200, Sandro Santilli  wrote:
On Tue, Oct 18, 2011 at 12:38:51AM -0400, maplabs at light42.com wrote:
> > What makes some tables show their geometry type as GEOMETRY while
> > others are POINT or MULTIPOLYGON, etc ?
>
> The column type. 
> GEOMETRY type now accept a modifier to express SRID and TYPE. 
>
> Try something like:
> ALTER TABLE geocoder_ca ALTER the_geom GEOMETRY(polygon, 4326);
>

thank you for this reply - but I do not understand this syntax
What is the meaning of  TYPE(param,param)  ? Is this explained somewhere?

thanks in advance
  -Brian

  > --strk;
>
>   ()   Free GIS & Flash consultant/developer
>   /\   http://strk.keybit.net/services.html
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>
>





More information about the postgis-devel mailing list