X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 39B06528A4 for ; Fri, 27 May 2005 16:11:40 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 92469-09 for ; Fri, 27 May 2005 19:11:39 +0000 (GMT) Received: from localhost.localdomain (unknown [12.31.43.201]) by svr1.postgresql.org (Postfix) with ESMTP id 9F69E52889 for ; Fri, 27 May 2005 16:11:37 -0300 (ADT) Received: from localhost.localdomain (localhost.localdomain [127.0.0.1]) by localhost.localdomain (8.13.1/8.13.1) with ESMTP id j4RJBbB6025506; Fri, 27 May 2005 15:11:37 -0400 Received: from localhost (localhost [[UNIX: localhost]]) by localhost.localdomain (8.13.1/8.13.1/Submit) id j4RJBakR025505; Fri, 27 May 2005 15:11:36 -0400 From: "Mark R. Dingee" To: Lori Subject: Re: better way Date: Fri, 27 May 2005 15:11:35 -0400 User-Agent: KMail/1.7.1 Cc: pgsql-admin@postgresql.org References: <429766C9.70902@dri.edu> In-Reply-To: <429766C9.70902@dri.edu> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200505271511.35894.mark.dingee@cox.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200505/284 X-Sequence-Number: 17713 if your output is from a query do insert into mytable(col1, col2, col3) (select col_a, col_b, col_c from othertable); or use the copy command ex. copy mytable from 'filepath/filename' using delimiters '\t'; you can also use stdin as the input path. On Friday 27 May 2005 02:28 pm, Lori wrote: > I have a bunch of insert into statements just wondering if anyone knows > of more succinct way of doing multiple > Insert Into mytable(col1,col2,co3 etc) values ('one','two','three'); > without repeating the Insert Into ? > thanks > Lori > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)