CREATE TEMPORARY TABLE ON COMMIT DROP

Поиск
Список
Период
Сортировка
От Luis Sousa
Тема CREATE TEMPORARY TABLE ON COMMIT DROP
Дата
Msg-id 43284E51.8000507@ualg.pt
обсуждение исходный текст
Ответы Re: CREATE TEMPORARY TABLE ON COMMIT DROP  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Hi all,

I'm tryng to write query that on commit drops the temporary table but 
I'm doing someting wrong.

According do documentation, I can create a temporary table using this 
syntax:
CREATE TEMP TABLE table_name AS SELECT * from table_select;
or I can create a table like this:
CREATE TEMP TABLE table_name (fld1 integer) ON COMMIT DROP;

But how can I create a table using a query and putting ON COMMIT DROP. 
Putting this on the end of the first sentence (CREATE TEMP TABLE 
table_name AS SELECT * from table_select ON COMMIT DROP;) gives the 
ERROR:  syntax error at or near "ON" at character 60.

Thanks in advance for you answers.
Luis Sousa


В списке pgsql-sql по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: What should this query match?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: CREATE TEMPORARY TABLE ON COMMIT DROP