Thread: SELECT * INTO TABLE is not working for me.
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
From: "Roy Souther" <roy@silicontao.com> > 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 Smith5 | Andrea Ottwick (2 rows) - Richard Huxton
"Roy Souther" <roy@silicontao.com> �������/�������� � �������� ���������: 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 <roy@silicontao.com> > > 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