Received: from anchor-post-34.mail.demon.net (anchor-post-34.mail.demon.net [194.217.242.92]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4VB4OE92346 for ; Thu, 31 May 2001 07:04:24 -0400 (EDT) (envelope-from dev@archonet.com) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-34.mail.demon.net with esmtp (Exim 2.12 #1) id 155QG1-000Esj-0Y; Thu, 31 May 2001 12:04:49 +0100 Received: from client (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with SMTP id 60FA412A88; Thu, 31 May 2001 11:52:52 +0100 (BST) Message-ID: <007e01c0e9bf$d6444e80$1001a8c0@archonet.com> From: "Richard Huxton" To: "Roy Souther" , References: <0105301102010Q.28903@OlympusMons> Subject: Re: SELECT * INTO TABLE is not working for me. Date: Thu, 31 May 2001 11:52:48 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200105/353 X-Sequence-Number: 3194 From: "Roy Souther" > I am testing my SQL commands in pgaccess before I put them into my C++ code. > Trying to copy a table using... > SELECT * INTO TABLE copy_stuff FROM the_stuff > > It creates the view but no table called copy_stuff exists after I run it. Why? > I can use... > CREATE TABLE copy_stuff AS SELECT * FROM the_stuff > that works and makes a new table, but it causes other problems with the > clients that this app is running from. I would like to make the SELECT * INTO > work. Any idea? Works here - can you give version info etc? richardh=> select * into table foo2 from foo; SELECT richardh=> select * from foo2; a | b ---+---------------------------------- 4 | Jack Smith 5 | Andrea Ottwick (2 rows) - Richard Huxton