Received: from web20806.mail.yahoo.com (web20806.mail.yahoo.com [216.136.226.195]) by postgresql.org (8.11.3/8.11.4) with SMTP id fAGGJcm33677 for ; Fri, 16 Nov 2001 11:19:38 -0500 (EST) (envelope-from jeff_eckermann@yahoo.com) Message-ID: <20011116161942.21392.qmail@web20806.mail.yahoo.com> Received: from [65.11.165.34] by web20806.mail.yahoo.com via HTTP; Fri, 16 Nov 2001 08:19:42 PST Date: Fri, 16 Nov 2001 08:19:42 -0800 (PST) From: Jeff Eckermann Subject: Re: Insert values from one existing table into a new table. To: Jeff Eckermann , Jason , pgsql-sql@postgresql.org In-Reply-To: <20011115154843.61029.qmail@web20807.mail.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200111/241 X-Sequence-Number: 5623 Whoops: should also lose the "values", i.e.: INSERT INTO new_table (values_of_AttributeA, values_of_AttributesB) SELECT AttibuteA, AttributeB FROM some_table; --- Jeff Eckermann wrote: > Lose the quotes, add a semicolon, and you already > have > the correct syntax :-) > --- Jason 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 > > ---------------------------(end of > broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please > send an appropriate > subscribe-nomail command to majordomo@postgresql.org > so that your > message can get through to the mailing list cleanly __________________________________________________ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com