[postgis-devel] Geometry Columns View

Sandro Santilli strk at keybit.net
Tue Oct 18 01:23:06 PDT 2011

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);


  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html

More information about the postgis-devel mailing list