[postgis-users] How to create table new_table as select * from old_table

Konstantin Tokar tokar at tokar.ru
Wed Jan 7 20:15:29 PST 2004


Hi

How to execute inquiry of type

create table new_table as select * from old_table;

old_table - preliminary created table, with a column geom. This column
is copied in new_table, but the description in geometry_columns for
new_table is not created. What it is necessary to make that it has
appeared in geometry_columns?

-- 
 Konstantin Tokar




More information about the postgis-users mailing list