X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id BE539D1BBB0 for ; Mon, 12 Jan 2004 01:10:14 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 50534-10 for ; Sun, 11 Jan 2004 21:09:46 -0400 (AST) Received: from mta06-svc.ntlworld.com (mta06-svc.ntlworld.com [62.253.162.46]) by svr1.postgresql.org (Postfix) with ESMTP id 75025D1B519 for ; Sun, 11 Jan 2004 21:09:42 -0400 (AST) Received: from [81.98.165.129] by mta06-svc.ntlworld.com (InterMail vM.4.01.03.37 201-229-121-137-20020806) with ESMTP id <20040112010946.HBAV1005.mta06-svc.ntlworld.com@[81.98.165.129]> for ; Mon, 12 Jan 2004 01:09:46 +0000 Mime-Version: 1.0 (Apple Message framework v609) Content-Transfer-Encoding: 7bit Message-Id: <010CB3A9-449C-11D8-9778-0003938366A4@beya-records.com> Content-Type: text/plain; charset=US-ASCII; format=flowed To: pgsql-sql@postgresql.org From: beyaRecords - The home Urban music Subject: Select into Date: Mon, 12 Jan 2004 01:09:43 +0000 X-Mailer: Apple Mail (2.609) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/85 X-Sequence-Number: 16478 Hi, I want to copy a sequence of rows from one table into another table. I have tried select into but this will only work if the table you are copying to does not already exist. How do I copy to a table that does already exist? regards Uzo