Andreas Laggner wrote:
Hello list,
i am searching for a solution for creating tables with less typing. I do
not want to type every column i want to have in my new table, especially
if column names will not change! I cannot use the postgresql "create
table tablename as select * from" because of the geometry column (with
this command i will insert all data the_geom included, but i will not
have the entries, that addgeometrycolumn does). Would be fine to create
the columns only first, then delete column the_geom, than execute
addgeometrycolumn and than execute the insert......but i do not know how
to create only the columns with *.
I am also happy about other approaches to solve the problem ;-)
cheers Andreas
If I'm not misstaken, probegeometrycolumns() should look at all your
tables and make sure that the geometry_columns table is updated to
reflect their current state.
-Steve
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
