Postgres Pro
Downloads
Home   >   mailing lists

Re: Insert values from one existing table into a new table. - Mailing list pgsql-sql

From Jeff Eckermann
Subject Re: Insert values from one existing table into a new table.
Date
Msg-id 20011115154843.61029.qmail@web20807.mail.yahoo.com
Whole thread Raw
In response to Insert values from one existing table into a new table.  ("Jason" <jzhu@dental.temple.edu>)
Responses Re: Insert values from one existing table into a new table.  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
List pgsql-sql
Tree view 
Lose the quotes, add a semicolon, and you already have
the correct syntax :-)
--- Jason <jzhu@dental.temple.edu> wrote:
> 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
> 
> 
> 
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


__________________________________________________
Do You Yahoo!?
Find the one for you at Yahoo! Personals
http://personals.yahoo.com

pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: INSERT question
Next
From: Jeff Eckermann
Date:
Subject: Re: Help with INSERT into 2 tables