[postgis-users] Incorrect geometry_columns?

[Sandro Santilli]

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;

--strk;