[postgis-devel] Geometry Columns View

[Sandro Santilli]

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

--strk;

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