pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
create temp table
2+ messages / 2 participants
[nested] [flat]

* create temp table
@ 1999-07-13 02:31 Steven Bradley <sbradley@llnl.gov>
  1999-07-13 05:05 ` Re: [SQL] create temp table Bruce Momjian <maillist@candle.pha.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Steven Bradley @ 1999-07-13 02:31 UTC (permalink / raw)
  To: 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [SQL] create temp table
  1999-07-13 02:31 create temp table Steven Bradley <sbradley@llnl.gov>
@ 1999-07-13 05:05 ` Bruce Momjian <maillist@candle.pha.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Bruce Momjian @ 1999-07-13 05:05 UTC (permalink / raw)
  To: Steven Bradley <sbradley@llnl.gov>; +Cc: pgsql-sql

> 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, Pennsylvania 19026



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1999-07-13 05:05 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-07-13 02:31 create temp table Steven Bradley <sbradley@llnl.gov>
1999-07-13 05:05 ` Bruce Momjian <maillist@candle.pha.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox