SELECT * INTO TABLE is not working for me. - Mailing list pgsql-sql

From Roy Souther
Subject SELECT * INTO TABLE is not working for me.
Date
Msg-id 0105301102010Q.28903@OlympusMons
Whole thread Raw
List pgsql-sql
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 <roy@silicontao.com>

01100010 10101110 11000110 11010110 00000100 10110010 10010110 11000110 
01001110 11110110 11001110 00010110 10010110 00101110 10000100 10000100 



pgsql-sql by date:

Previous
From: "Koen Antonissen"
Date:
Subject: RE: primary key scans in sequence
Next
From: Tom Lane
Date:
Subject: Re: Case Insensitive Queries