SELECT * INTO TABLE is not working for me.

From: Roy Souther <roy(at)silicontao(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: SELECT * INTO TABLE is not working for me.
Date: 2001-05-30 17:02:01
Message-ID: 0105301102010Q.28903@OlympusMons
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I am testing my SQL commands in pgaccess before I put them into my C++ code.
Trying to copy a table using...
SELECT * INTO TABLE copy_stuff FROM the_stuff

It creates the view but no table called copy_stuff exists after I run it. Why?
I can use...
CREATE TABLE copy_stuff AS SELECT * FROM the_stuff
that works and makes a new table, but it causes other problems with the
clients that this app is running from. I would like to make the SELECT * INTO
work. Any idea?

--
Roy Souther <roy(at)silicontao(dot)com>

01100010 10101110 11000110 11010110 00000100 10110010 10010110 11000110
01001110 11110110 11001110 00010110 10010110 00101110 10000100 10000100

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2001-05-30 17:34:38 Re: bpchar compares (was Re: Case Insensitive Queries)
Previous Message Tom Lane 2001-05-30 16:53:22 Re: Case Insensitive Queries