[postgis-users] create tables smarter

[Obe, Regina]

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: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] 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: andreas.laggner at vti.bund.de
Homepage: http://www.vti.bund.de

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
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.