Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 68CB06327DA
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu,  6 Aug 2009 05:42:20 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 26844-01 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu,  6 Aug 2009 08:42:09 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from relay.pcl-ipout02.plus.net (relay.pcl-ipout02.plus.net
	[212.159.7.100])
	by mail.postgresql.org (Postfix) with ESMTP id C1EEB634625
	for <pgsql-sql@postgresql.org>; Thu,  6 Aug 2009 05:42:09 -0300 (ADT)
X-IronPort-Anti-Spam-Filtered: true
X-IronPort-Anti-Spam-Result: ApoEALQ0ekrUnw6T/2dsb2JhbADUcIQYBQ
Received: from ptb-relay03.plus.net ([212.159.14.147])
	by relay.pcl-ipout02.plus.net with ESMTP; 06 Aug 2009 09:42:07 +0100
Received: from [84.51.143.99] (helo=server3.office.archonet.com)
	by ptb-relay03.plus.net with esmtp (Exim) id 1MYyY3-0000IS-Du;
	Thu, 06 Aug 2009 09:42:07 +0100
Received: from dell36.office.archonet.com (dell36.office.archonet.com
	[192.168.1.36])
	by server3.office.archonet.com (Postfix) with ESMTP id 26D89274067;
	Thu,  6 Aug 2009 09:42:07 +0100 (BST)
Message-ID: <4A7A975E.8050403@archonet.com>
Date: Thu, 06 Aug 2009 09:42:06 +0100
From: Richard Huxton <dev@archonet.com>
User-Agent: Thunderbird 2.0.0.21 (X11/20090320)
MIME-Version: 1.0
To: Klas Stockhem <Klas.Stockhem@benders.se>
CC: PostgreSQL <pgsql-sql@postgresql.org>
Subject: Re: Problems when copy data from dump file
References: <2A250781A3744D48B1529FCC3C2EB8ABCB48FF@comserver.benders.se>
In-Reply-To: <2A250781A3744D48B1529FCC3C2EB8ABCB48FF@comserver.benders.se>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Plusnet-Relay: f10767fbfbb093df40741a94e0f8db5b
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.185 tagged_above=-10 required=5
	tests=BAYES_40=-0.185
X-Spam-Level: 
X-Archive-Number: 200908/24
X-Sequence-Number: 32933

Klas Stockhem wrote:

 > The data in the dump file are structured and I want to execute this
 > automatically (copy+paste it) in the EMS software.
 > I still get the syntax error even if I use the command you send me:
 > COPY artikkel (id, tittel, tekst) FROM stdin; 1<tab>Title one<tab>Some
 > text \.

Why not just load the dump file into PostgreSQL? Why are you trying to 
copy+paste if you want the entire dump?

-- 
   Richard Huxton
   Archonet Ltd