X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 446499DCBD2 for ; Thu, 23 Mar 2006 11:08:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 48867-03 for ; Thu, 23 Mar 2006 11:08:47 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from he100.hostelement.com (unknown [64.246.26.51]) by postgresql.org (Postfix) with ESMTP id 1780E9DC89E for ; Thu, 23 Mar 2006 11:08:40 -0400 (AST) Received: from [64.213.65.29] (helo=[127.0.0.1]) by he100.hostelement.com with esmtpa (Exim 4.52) id 1FMRQa-0005tK-7K for pgsql-general@postgresql.org; Thu, 23 Mar 2006 10:08:44 -0500 Message-ID: <4422B9F8.60100@oisinglynn.com> Date: Thu, 23 Mar 2006 10:08:40 -0500 From: Oisin Glynn User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: pgsql general Subject: COPY command documentation Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - he100.hostelement.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - oisinglynn.com X-Source: X-Source-Args: X-Source-Dir: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.087 required=5 tests=[AWL=0.087] X-Spam-Score: 0.087 X-Spam-Level: X-Archive-Number: 200603/1075 X-Sequence-Number: 92940 I have driven myself to distraction for the last 30 minutes trying to get COPY to work on Windows XP. The Unix style c:/afolder/afile instead of c:\afolder\afile was a desperation attempt. I had tried all sorts of double slashes \\ putting the whole path in quotes basically all sorts of foolishness. I would suggest the there should be a Windows example(s) in the documents as well as a *NIX style one(s) where necessary. Did I miss this somewhere or should I put a comment on the doc or what can I do to help the next Windows user. Oisin P.S. I just discovered that the comments from 8.0 had the answer I was looking for but these comments are not in the 8.1 docs. Should the comments be rolled forward as new versions are created? Or if valid comments added to the docs themselves? http://www.postgresql.org/docs/8.1/interactive/sql-copy.html http://www.postgresql.org/docs/8.0/interactive/sql-copy.html Now happily using COPY, Oisin