[postgis-users] Incorrect geometry_columns?
strk at keybit.net
Mon Dec 10 06:22:08 PST 2012
On Mon, Dec 10, 2012 at 01:02:46PM +0100, Nicolas Ribot wrote:
> To take advantage of the gc view, geometric tables have to be created with
> a typemod on the geometry type, to allow system to know both geoemtry's
> type and SRID.
> If you create the table by a "create table as select ...", you would have
> to alter the table to use the typemod:
> create table test as select code_dept, st_centroid(geom) as geom from dept;
Or to cast on select (very useful with views..)
create table test as select code_dept,
st_centroid(geom)::geometry(point, 2154) as geom from dept;
More information about the postgis-users