Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group