create table as problem

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

Responses

Browse pgsql-novice by date

  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