create table as problem
От | Frances Collier |
---|---|
Тема | create table as problem |
Дата | |
Msg-id | 20050928170736.24F60D9AB9@svr1.postgresql.org обсуждение исходный текст |
Ответы |
Re: create table as problem
Re: create table as problem |
Список | pgsql-novice |
I am trying to copy some rows from a table to another table using “create table as” but I keep getting a “column name ‘ogc_fid’ is duplicated” error. Can anyone tell me why this is happening?
The postgres statement:
create table skamaniaTable as
select *
from wacounties a,
wacounties b
where b.county_nm='Skamania' and
a.wkb_geometry && b.wkb_geometry and
distance(a.wkb_geometry, b.wkb_geometry) = 0;
The table fields:
ogc_fid :: int, wkb_geometry :: geometry, area :: float, perimeter :: float, wacounties :: int, wacounti_1 :: int, county_cod :: int, county_fip :: varchar, county_nm :: varchar, ecy_region :: varchar, air_region :: varchar, shape_leng :: float, shape_area :: float
Any help would be greatly appreciated.
Thank you,
Frances Collier
В списке pgsql-novice по дате отправления: