create temp table - Mailing list pgsql-sql

From Steven Bradley
Subject create temp table
Date
Msg-id 3.0.3.32.19990712213105.007af3e0@poptop.llnl.gov
Whole thread Raw
Responses Re: [SQL] create temp table  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-sql
When I try to create a temporary table using the following command:
 create temp table foo as select * from employees;

I get the following error:
 ERROR:  parser: parse error at or near "temp"

I get a similar error if I try:
 create temporary table foo as select * from employees;


Can anyone tell me what I'm doing wrong?  This seems so simple!

Thanks in advance...

PS: I'm using PostgreSQL 6.4.2.

Steven Bradley
Lawrence Livermore National Laboratory
Livermore, California 94550
sbradley@llnl.gov


pgsql-sql by date:

Previous
From: Chris Bitmead
Date:
Subject: Re: [SQL] variables in pgSQL?
Next
From: "Mr. Poet"
Date:
Subject: Using Indexes