Received: from office.knowledge.com (office.knowledge.com [195.40.167.196]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA43675 for ; Fri, 15 Oct 1999 09:14:38 -0400 (EDT) (envelope-from Mark.Jewiss@knowledge.com) Received: from mark (helo=localhost) by office.knowledge.com with local-esmtp (Exim 2.10 #1) id 11c7BL-0002np-00; Fri, 15 Oct 1999 14:14:03 +0100 Date: Fri, 15 Oct 1999 14:14:03 +0100 (BST) From: Mark Jewiss To: John C Cusick cc: pgsql-sql@postgresql.org Subject: Re: [SQL] HOW DO I... In-Reply-To: <19991015.085403.-768299.0.jcc2@juno.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Hello, On Fri, 15 Oct 1999, John C Cusick wrote: > In other words, if I do a: > select * into tblB from tblA where attrN like 'xxx'; > > and both table structures are identical I get a > ERROR: Relation 'tblB' already exists Correct, the 'select into...' statement attempts to create the table, not just insert rows. I had this problem on a different system (which I haven't tried to do in pgsql), where the solution was: insert into tbl1 select * from tbl2 where this = that I *think* you could declare a value list as in a normal insert. I also think that this is SQL, not something specific to that db system, but I may be wrong. Regards, Mark. -- Mark Jewiss Knowledge Matters Limited http://www.knowledge.com