[postgis-users] how to handle table

[gates jr]

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 rates starting at 1¢/min.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060804/390f258a/attachment.html>