[postgis-devel] Geometry Columns View
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
More information about the postgis-devel