AW: [postgis-users] how to handle table

[Düster Horst]

>select * from pointcity, pointcountry --- I thought it wasn't valid
 
To combine two equal tables you can use the UNION option:
 
select * from pointcity union select * from pointcountry;
 
If you like to create a new table you can use
 
create table pointall as select * from pointcity union select * from
pointcountry;
 
Don't forget to create a spatial index on the_geom.
 
With best regards 
Horst Düster

---------------------------------------------
 
Dr. Horst Düster
GIS-Koordinator, Stv. Amtschef

Kanton Solothurn 
Amt für Geoinformation
Abteilung SO!GIS® Koordination
Rötistrasse 4
CH-4501 Solothurn

Tel.: ++41 (0)32 627 25 32
Fax: ++41 (0)32 627 22 14

horst.duester at bd.so.ch
www.sogis.so.ch



 

-----Ursprüngliche Nachricht-----
Von: gates jr [mailto:mr_gates_jr at yahoo.com]
Gesendet am: Freitag, 4. August 2006 11:20
An: postgis-users at postgis.refractions.net
Betreff: [postgis-users] how to handle table

I have 2 tables from shp file named poincity, pointcountry
1. Each table consist of hundred thousand points
2. Both have the same column (gid, name, ...., the_geom)
I want to create a new table that include all row in pointcity and
pointcountry with the same column (gid, name, ...., the_geom). 
I try to use query

select * from pointcity, pointcountry --- I thought it wasn't valid
What's the right query to create that table?
 
Thanks



  _____  

Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great
<http://us.rd.yahoo.com/mail_us/taglines/postman7/*http://us.rd.yahoo.com/ev
t=39666/*http://messenger.yahoo.com> rates starting at 1¢/min.