Received: from femail38.sdc1.sfba.home.com (femail38.sdc1.sfba.home.com [24.254.60.32]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f83H5s742168 for ; Mon, 3 Sep 2001 13:05:54 -0400 (EDT) (envelope-from joseph.conway@home.com) Received: from jecw2k1 ([24.0.42.111]) by femail38.sdc1.sfba.home.com (InterMail vM.4.01.03.20 201-229-121-120-20010223) with SMTP id <20010903170549.FZXI24024.femail38.sdc1.sfba.home.com@jecw2k1>; Mon, 3 Sep 2001 10:05:49 -0700 Message-ID: <014d01c1349a$b01727c0$0705a8c0@jecw2k1> From: "Joe Conway" To: "Joseph Syjuco" , References: Subject: Re: Date: Mon, 3 Sep 2001 10:05:51 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200109/5 X-Sequence-Number: 4648 > im new in postgresql (actually came from SQL Server) and i was trying a > script like this > > insert into table1(field1,field2) values (select field1, field2 from table > 2); > > i dont know if this is possible (inserting a set of entries via resultset > from a select stmt in one command). If anyone has any answers, or > workarounds pls do email me Well, that syntax doesn't work on SQL Server either. I think what you want is: insert into table1(field1,field2) select field1, field2 from table2; HTH, -- Joe