Insert values from one existing table into a new table.

From: "Jason" <jzhu(at)dental(dot)temple(dot)edu>
To: pgsql-sql(at)postgresql(dot)org
Subject: Insert values from one existing table into a new table.
Date: 2001-11-13 16:43:12
Message-ID: 9srij6$gre$1@cronkite.temple.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I want to insert the existing values of one table into a new table. It
needs the combination of these to sql commands:

" insert into new_table values ( values_of_AtrributeA,
values_of_AttributesB) "
" select AttributeA, AttributeB from some_table "

Thanks for your suggestions! -- Jason

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jack Gao 2001-11-13 18:07:56 Re: Is this a bug?
Previous Message Gintas 2001-11-13 13:42:08 Help with INSERT into 2 tables