Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id E572C6324FB
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu,  6 Aug 2009 07:01:01 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 04402-02 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu,  6 Aug 2009 10:00:45 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail.benders.se (mail.benders.se [212.247.52.15])
	by mail.postgresql.org (Postfix) with ESMTP id C725763271F
	for <pgsql-sql@postgresql.org>; Thu,  6 Aug 2009 07:00:50 -0300 (ADT)
Received: from comserver.benders.se (Not Verified[100.100.100.171]) by
	mail.benders.se with MailMarshal (v6, 1, 8, 2172)
	id <B4a7aa9ce0000>; Thu, 06 Aug 2009 12:00:46 +0200
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
X-MimeOLE: Produced By Microsoft Exchange V6.5
Subject: Problems when copy data from dump file
Date: Thu, 6 Aug 2009 12:00:46 +0200
Message-ID: <2A250781A3744D48B1529FCC3C2EB8ABCB4934@comserver.benders.se>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: [SQL] Problems when copy data from dump file
thread-index: AcoWcdGpPsvRAiguRVK5D1o/pENLbQAB6pvQ
From: "Klas Stockhem" <Klas.Stockhem@benders.se>
To: "Richard Huxton" <dev@archonet.com>
Cc: "PostgreSQL" <pgsql-sql@postgresql.org>
X-CT-RefID: str=0001.0A0B0206.4A7AA9C2.00B1,ss=1,fgs=0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.05 tagged_above=-10 required=5 tests=AWL=-0.309,
	BAYES_20=-0.74
X-Spam-Level: 
X-Archive-Number: 200908/31
X-Sequence-Number: 32940




 > 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=20
copy+paste if you want the entire dump?

--=20
   Richard Huxton
   Archonet Ltd


>
>
>
I have tried to load the dump file also but get same error.

I have check the sql dump file in Ultra editor 32 where you can see the
hex value of each character in the file I see the both the original dump
file and my copy+paste text contain a tab (hex value 09).

Note that I have "CREATE TABLE" script in the dump file and this was
executed good in the server. This was copy+pasted also.

Maybe you can send me an create table script and one row of a copy
command and I can execute this and see if it works?

//Klas =20