[postgis-users] how to handle table

[Steffen Macke]

On 8/2/06, gates jr <mr_gates_jr at yahoo.com> wrote:
>
> 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).
> What's the right query to create that table?

Hi,

please try

create table poinall as select * from poincity union select * from poincountry

Regards,

Steffen