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 -- Dipl. Geoökologe Andreas Laggner Institut für Agrarrelevante Klimaforschung (AK) des vTI Johann Heinrich von Thünen-Institut (vTI), Bundesforschungsinstitut für Ländliche Räume, Wald und Fischerei Institute of Agricultural Climate Research (AK) of the vTI Johann Heinrich von Thünen-Institute (vTI), Federal Research Institute for Rural Areas, Forestry and Fisheries Bundesallee 50 D-38116 Braunschweig Tel.: (+49) (0)531 596 2636 E-mail: [EMAIL PROTECTED] Homepage: http://www.vti.bund.de _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
