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
