Not sure if this helps. But take a look at this. http://www.postgresonline.com/journal/index.php?/archives/41-How-to-SELECT--ALL-EXCEPT-some-columns-in-a-table.html
Hope that helps, Regina -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andreas Laggner Sent: Wednesday, June 04, 2008 10:29 AM To: PostGis_Mailinglist Subject: [postgis-users] create tables smarter 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 ----------------------------------------- The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
