From: | "Frances Collier" <fcollier(at)preparedresponse(dot)com> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | create table as problem |
Date: | 2005-09-28 17:07:34 |
Message-ID: | 20050928170736.24F60D9AB9@svr1.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Lane Van Ingen | 2005-09-28 20:12:44 | Timestamps Look Incorrect? |
Previous Message | Tom Lane | 2005-09-28 14:47:08 | Re: createlang issue in XP |