Received: from web20807.mail.yahoo.com (web20807.mail.yahoo.com [216.136.226.196]) by postgresql.org (8.11.3/8.11.4) with SMTP id fAFG0Mm18771 for ; Thu, 15 Nov 2001 11:00:22 -0500 (EST) (envelope-from jeff_eckermann@yahoo.com) Message-ID: <20011115154843.61029.qmail@web20807.mail.yahoo.com> Received: from [65.11.165.34] by web20807.mail.yahoo.com via HTTP; Thu, 15 Nov 2001 07:48:43 PST Date: Thu, 15 Nov 2001 07:48:43 -0800 (PST) From: Jeff Eckermann Subject: Re: Insert values from one existing table into a new table. To: Jason , pgsql-sql@postgresql.org In-Reply-To: <9srij6$gre$1@cronkite.temple.edu> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200111/208 X-Sequence-Number: 5592 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