Received: from albatross.prod.itd.earthlink.net (albatross.mail.pas.earthlink.net [207.217.120.120]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f83GTV730863 for ; Mon, 3 Sep 2001 12:29:32 -0400 (EDT) (envelope-from mdavis@sevainc.com) Received: from SALLY (cpe-66-1-238-71.co.sprintbbd.net [66.1.238.71]) by albatross.prod.itd.earthlink.net (EL-8_9_3_3/8.9.3) with SMTP id JAA16148; Mon, 3 Sep 2001 09:29:19 -0700 (PDT) Received: by localhost with Microsoft MAPI; Mon, 3 Sep 2001 10:29:13 -0600 Message-ID: <01C13463.46CD2260.mdavis@sevainc.com> From: Michael Davis Reply-To: "mdavis@sevainc.com" To: "'Joseph Syjuco'" , "pgsql-sql@postgresql.org" Subject: Re: Date: Mon, 3 Sep 2001 10:29:12 -0600 X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Archive-Number: 200109/6 X-Sequence-Number: 4652 Try: Create table table1(field1,field2) as (select field1, field2 from table2); -----Original Message----- From: Joseph Syjuco [SMTP:joseph@asti.dost.gov.ph] Sent: Monday, September 03, 2001 3:03 AM To: pgsql-sql@postgresql.org Subject: 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 Thanks ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl