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

Simon O'Malley simonom at gmail.com
Mon Jun 19 01:01:09 PDT 2006


Hi List

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

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060619/47b24f51/attachment.html>


More information about the postgis-users mailing list