Thread: create temp table

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

> Can anyone tell me what I'm doing wrong?  This seems so simple!
> 
> Thanks in advance...
> 
> PS: I'm using PostgreSQL 6.4.2.
> 

Only 6.5 has temp tables.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026