Re: create table as problem

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Frances Collier <fcollier(at)preparedresponse(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: create table as problem
Date: 2005-10-07 00:32:33
Message-ID: 20051007003233.GB19015@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Browse pgsql-novice by date

  From Date Subject
Next Message Jonathan Tse 2005-10-07 02:34:48 Re: Order by and index
Previous Message Bruno Wolff III 2005-10-07 00:29:33 Re: create table as problem