Re: CREATE TEMPORARY TABLE ON COMMIT DROP

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Luis Sousa <llsousa(at)ualg(dot)pt>
Cc: "pgsql-sql(at)postgresql(dot)org" <Pgsql-sql(at)postgresql(dot)org>
Subject: Re: CREATE TEMPORARY TABLE ON COMMIT DROP
Date: 2005-09-14 17:08:04
Message-ID: 5796.1126717684@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Luis Sousa <llsousa(at)ualg(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Ferindo Middleton Jr 2005-09-15 01:11:37 showing multiple REFERENCE details of id fields in single query that share the same table
Previous Message Luis Sousa 2005-09-14 16:22:41 CREATE TEMPORARY TABLE ON COMMIT DROP