[postgis-users] a newbie question

[Uwe Seher]

Am 21.03.2007, 11:22 Uhr, schrieb Gustavo Ces <g.ces at pettra.es>:

> Sorry about this question,
>
>     i want to create another table from selecting a previous one ( with  
> the_geom and gid)
>
> create table foo as select gid, the_geom, other_columns from  
> previous_table
>
> this query creates the table with the other columns, gid and geom but if  
> try to open it in a client, it fails.
>
> Which is the problem?
>
> Thanks,
>
> Galois

Hi!

If you do it in this way, the geometry-column is not correct registered in  
the table geometry_columns. Maybe this is a problem.

Bye Uwe

-- 
_____________________________________
ingenieurbüro kauppert

nebeniusstr. 34
d-76137 karlsruhe

fon   +49 721 3548969-3
fax   +49 721 3548969-5

email uwe.seher at ib-kauppert.de
web   www.ib-kauppert.de
_____________________________________