create temp table

From: Steven Bradley <sbradley(at)llnl(dot)gov>
To: pgsql-sql(at)postgresql(dot)org
Subject: create temp table
Date: 1999-07-13 02:31:05
Message-ID: 3.0.3.32.19990712213105.007af3e0@poptop.llnl.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)llnl(dot)gov

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Heinz Hemken 1999-07-13 02:41:54 variables in pgSQL?
Previous Message Heinz Hemken 1999-07-13 02:18:36 variables in pgSQL?