[postgis-users] a newbie question

[Gustavo Ces]

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