Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f55JQ5E59345 for ; Tue, 5 Jun 2001 15:26:05 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4V7wDE22460 for ; Thu, 31 May 2001 03:58:13 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f4V7vPp66760 for pgsql-sql@postgresql.org; Thu, 31 May 2001 03:57:25 -0400 (EDT) (envelope-from news) From: "Sergey E. Volkov" X-Newsgroups: comp.databases.postgresql.sql Subject: Re: SELECT * INTO TABLE is not working for me. Date: Thu, 31 May 2001 11:54:40 +0400 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 32 Message-ID: <9f4th2$2166$1@news.tht.net> References: <0105301102010Q.28903@OlympusMons> X-Complaints-To: scrappy@hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 To: pgsql-sql@postgresql.org X-Archive-Number: 200106/39 X-Sequence-Number: 3242 "Roy Souther" сообщил/сообщила в новостях следующее: news:0105301102010Q.28903@OlympusMons... > 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 Works only when 'copy_stuff' table is not exists for now. If you want to populate existing table, just use ' insert into copy_stuff select * 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster