create table as problem

Поиск
Список
Период
Сортировка
От Frances Collier
Тема create table as problem
Дата
Msg-id 20050928170736.24F60D9AB9@svr1.postgresql.org
обсуждение исходный текст
Ответы Re: create table as problem  (Bruno Wolff III <bruno@wolff.to>)
Re: create table as problem  (Bruno Wolff III <bruno@wolff.to>)
Список 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 по дате отправления:

Предыдущее
От: Kretschmer Andreas
Дата:
Сообщение: Re: Transaction within plpgsql
Следующее
От: Steve Tucknott
Дата:
Сообщение: Importing Later Release.....