Received: from priv-edtnes11-hme0.telusplanet.net (fepout3.telus.net [199.185.220.238]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4UGonE66287 for ; Wed, 30 May 2001 12:50:49 -0400 (EDT) (envelope-from roy@silicontao.com) Received: from OlympusMons ([161.184.77.113]) by priv-edtnes11-hme0.telusplanet.net (InterMail vM.4.01.03.13 201-229-121-113) with SMTP id <20010530165048.SSBD9123.priv-edtnes11-hme0.telusplanet.net@OlympusMons> for ; Wed, 30 May 2001 10:50:48 -0600 Content-Type: text/plain; charset="iso-8859-1" From: Roy Souther Reply-To: Roy Souther Organization: Silicon Tao Technology Systems To: pgsql-sql@postgresql.org Subject: SELECT * INTO TABLE is not working for me. Date: Wed, 30 May 2001 11:02:01 -0600 X-Mailer: KMail [version 1.2] MIME-Version: 1.0 Message-Id: <0105301102010Q.28903@OlympusMons> Content-Transfer-Encoding: 8bit X-Archive-Number: 200105/336 X-Sequence-Number: 3177 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? -- Roy Souther 01100010 10101110 11000110 11010110 00000100 10110010 10010110 11000110 01001110 11110110 11001110 00010110 10010110 00101110 10000100 10000100