Re: create table as problem - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: create table as problem
Date
Msg-id 20051007003233.GB19015@wolff.to
Whole thread Raw
In response to create table as problem  ("Frances Collier" <fcollier@preparedresponse.com>)
List pgsql-novice
On Wed, Sep 28, 2005 at 10:07:34 -0700,
  Frances Collier <fcollier@preparedresponse.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.

pgsql-novice by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: create table as problem
Next
From: Jonathan Tse
Date:
Subject: Re: Order by and index