SELECT * INTO TABLE is not working for me.

Поиск
Список
Период
Сортировка
От Roy Souther
Тема SELECT * INTO TABLE is not working for me.
Дата
Msg-id 0105301102010Q.28903@OlympusMons
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "Koen Antonissen"
Дата:
Сообщение: RE: primary key scans in sequence
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Case Insensitive Queries