"Roy Souther" <[EMAIL PROTECTED]> сообщил/сообщила в новостях следующее:
0105301102010Q.28903@OlympusMons">news:0105301102010Q.28903@OlympusMons...
> 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
Works only when 'copy_stuff' table is not exists for now.
If you want to populate existing table, just use ' insert into copy_stuff
select * 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 <[EMAIL PROTECTED]>
>
> 01100010 10101110 11000110 11010110 00000100 10110010 10010110 11000110
> 01001110 11110110 11001110 00010110 10010110 00101110 10000100 10000100
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
