Postgres Pro
Downloads
Home   >   mailing lists

Re: CREATE TEMPORARY TABLE ON COMMIT DROP - Mailing list pgsql-sql

From Tom Lane
Subject Re: CREATE TEMPORARY TABLE ON COMMIT DROP
Date
Msg-id 5796.1126717684@sss.pgh.pa.us
Whole thread Raw
In response to CREATE TEMPORARY TABLE ON COMMIT DROP  (Luis Sousa <llsousa@ualg.pt>)
List pgsql-sql
Tree view 
Luis Sousa <llsousa@ualg.pt> writes:
> But how can I create a table using a query and putting ON COMMIT DROP. 

You can't.  Use INSERT ... SELECT to fill the table, instead.
        regards, tom lane

pgsql-sql by date:

Previous
From: Luis Sousa
Date:
Subject: CREATE TEMPORARY TABLE ON COMMIT DROP
Next
From: Ferindo Middleton Jr
Date:
Subject: showing multiple REFERENCE details of id fields in single query that share the same table