Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fADLbjm52010 for ; Tue, 13 Nov 2001 16:37:45 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id fADLZIf36350 for pgsql-sql@postgresql.org; Tue, 13 Nov 2001 16:35:18 -0500 (EST) (envelope-from news) From: "Wilco Boschman" X-Newsgroups: comp.databases.postgresql.sql References: <9srij6$gre$1@cronkite.temple.edu> Subject: Re: Insert values from one existing table into a new table. Date: Tue, 13 Nov 2001 22:33:03 +0100 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Lines: 30 Message-ID: <3bf1920f$0$201$e4fe514c@newszilla.xs4all.nl> To: pgsql-sql@postgresql.org X-Archive-Number: 200111/195 X-Sequence-Number: 5579 Assuming that the structure of the tables are identical, you could do a: insert into new_table select * from some_table; If they are not the same you could do a: insert into new_table (column1, column2) select column1, column2 from some_table; Cheers, Wilco Boschman "Jason" schreef in bericht news:9srij6$gre$1@cronkite.temple.edu... | 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 | | |