[postgis-users] Create table as doesn't populate geometry_columns

[Brent Wood]

--- Simon O'Malley <simonom at gmail.com> wrote:

> Hi List
> 
> Should a create table as select statement also add an entry into the
> geometry_columns table.
> 

Hi Simon.

Debatable. I'd like to think it should, but it doesn't :-)

Geometry_column entries are only created by creategeometrycolumn(), for tables
created by selects, or views, you'll need to do it manually.

Brent


> i.e.
> 
> create table table1 as select id, transform(shape, 4326) as shape from
> table;
> 
> select * from geometry_columns where f_table_name = 'table1';
> ------
> (0 rows)
> 
> Or is there something I have missed?
> 
> Cheers
> Simon
> > _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>