create table as problem

Поиск
Список
Период
Сортировка
Искать
От
Frances Collier
Тема
create table as problem
Дата
Msg-id
20050928170736.24F60D9AB9@svr1.postgresql.org
Список
Дерево обсуждения
create table as problem "Frances Collier" <fcollier@preparedresponse.com>
Re: create table as problem Bruno Wolff III <bruno@wolff.to>
Re: create table as problem Bruno Wolff III <bruno@wolff.to>

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 по дате отправления
От: Kretschmer Andreas
Дата:
Сообщение: Re: Transaction within plpgsql
От: Steve Tucknott
Дата:
Сообщение: Importing Later Release.....
FAQ