[postgis-users] create tables smarter

Stephen Woodbridge woodbri at swoodbridge.com
Wed Jun 4 08:57:37 PDT 2008

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.


More information about the postgis-users mailing list