select into without creating new table - Mailing list pgsql-general

Hi,

How can I select data from table into an existing table. I've redesigned
some tables and thus want my data to be copied from the old table to the new
one. Since the column order, names (and the number of columns) is not equal
i thought of using:

select column1,column2 into newtable from oldtable

THis however leads to an error that states that the table exists already.
Deleting the table is no option for me since I want the data to be in the
table with the new structure.

Any help would be appreciated!




-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
   http://www.newsfeed.com       The #1 Newsgroup Service in the World!
-----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----