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.