X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 3C06AD1BB95 for ; Thu, 4 Mar 2004 06:02:20 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 25263-10 for ; Thu, 4 Mar 2004 02:02:02 -0400 (AST) Received: from secure.icanx.com (secure.icanx.com [64.246.58.55]) by svr1.postgresql.org (Postfix) with ESMTP id D9467D1B8C3 for ; Thu, 4 Mar 2004 02:02:02 -0400 (AST) Received: from 63-229-201-197.mpls.qwest.net ([63.229.201.197] helo=[192.168.2.102]) by secure.icanx.com with esmtp (Exim 4.24) id 1Aylvl-0001xu-6e; Thu, 04 Mar 2004 01:02:01 -0500 In-Reply-To: <21695.1078377654@sss.pgh.pa.us> References: <21228.1078374155@sss.pgh.pa.us> <9319A042-6D9A-11D8-B976-000A9579AF50@indeq.com> <21695.1078377654@sss.pgh.pa.us> Mime-Version: 1.0 (Apple Message framework v612) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: <71BAE198-6DA1-11D8-8073-000A9579AF50@indeq.com> Content-Transfer-Encoding: 7bit Cc: pgsql-admin@postgresql.org From: Mark Lubratt Subject: Re: Multiple inserts without COPY Date: Thu, 4 Mar 2004 00:01:57 -0600 To: Tom Lane X-Mailer: Apple Mail (2.612) X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - secure.icanx.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [0 0] / [47 12] X-AntiAbuse: Sender Address Domain - indeq.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/22 X-Sequence-Number: 12592 On Mar 3, 2004, at 11:20 PM, Tom Lane wrote: > Mark Lubratt writes: >>> Huh? You can use COPY FROM STDIN in most of our client libraries, >>> certainly so with libpq. What are you using? > >> Actually, I'm using REALbasic. > > Um. I have no idea what sort of support they have, but you do need a > client interface library that knows about the COPY data protocol. > Typically there will be separate API calls for pushing COPY data > through > after you issue the COPY command. > > I figured it out. They do provide a string to push COPY FROM STDIN through. Thanks anyway! Mark