On Wed, Sep 28, 2005 at 10:07:34 -0700,
Frances Collier <fcollier(at)preparedresponse(dot)com> wrote:
> 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?
I made a slight oops in my last message, the newly created table needs unique
names so a.*, b.* won't work unless you explicitly name the columns for it.
In response to
pgsql-novice by date
|Next:||From: Jonathan Tse||Date: 2005-10-07 02:34:48|
|Subject: Re: Order by and index|
|Previous:||From: Bruno Wolff III||Date: 2005-10-07 00:29:33|
|Subject: Re: create table as problem|