Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 0176963272D for ; Mon, 3 Aug 2009 08:16: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 85330-01 for ; Mon, 3 Aug 2009 11:15:43 +0000 (UTC) X-Greylist: delayed 00:15:03.520004 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 9083C6332D8 for ; Mon, 3 Aug 2009 08:15:49 -0300 (ADT) Received: from comserver.benders.se (Not Verified[100.100.100.171]) by mail.benders.se with MailMarshal (v6, 1, 8, 2172) id ; Mon, 03 Aug 2009 13:00:54 +0200 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01CA1429.ABE9747D" X-MimeOLE: Produced By Microsoft Exchange V6.5 Subject: Problems when copy data from dump file Date: Mon, 3 Aug 2009 13:00:53 +0200 Message-ID: <2A250781A3744D48B1529FCC3C2EB8ABCB465E@comserver.benders.se> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Problems when copy data from dump file thread-index: AcoUKatxQu6GqIChQoWfVO6+4kn2gA== From: "Klas Stockhem" To: X-CT-RefID: str=0001.0A0B0206.4A76C35B.005D,ss=1,fgs=0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.739 tagged_above=-10 required=5 tests=BAYES_20=-0.74, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200908/8 X-Sequence-Number: 32917 This is a multi-part message in MIME format. ------_=_NextPart_001_01CA1429.ABE9747D Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I get an error when I'm trying to fill my table with data. I have a postgresql dump file and copy-paste the text from the file into my webbased phppgadmin interface. I have created my tables correctly. Down here I have post the error message I get. I suppose it's something with the tab between "5" and the text? I have tried to make both tab and single space but I get the same error both times. =20 SQL error: ERROR: syntax error at or near "5" LINE 2: 5 Slitasje og vedlikehold PRAKTISKE OPPLYSNINGER\r\n\r\nSn&#... ^ =20 =20 COPY artikkel (id, tittel, tekst) FROM stdin; 5 Slitasje og vedlikehold PRAKTISKE OPPLYSNINGER\r\n\r\nSnø og is.\r\nSnør...and more text... \. =20 =20 Does anyone have some tips to an solution? =20 The postgresql version is 7.4.17. =20 =20 ------_=_NextPart_001_01CA1429.ABE9747D Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I get an error when I’m trying to fill = my table with data. I have a postgresql dump file and copy-paste the text from = the file into my webbased phppgadmin interface. I have created my tables = correctly.

Down here I have post the error message I get. = I suppose it’s something with the tab between = “5” and = the text? I have tried to make both tab and single space but I get the same error = both times.

SQL error:

ERROR: syntax error at or near = "5"

LINE 2: 5 Slitasje og vedlikehold PRAKTISKE OPPLYSNINGER\r\n\r\nSn&#...

= ^

COPY artikkel (id, tittel, tekst) FROM = stdin;

5 = ; Slitasje = og = vedlikehold &n= bsp; PRAKTISKE OPPLYSNINGER\r\n\r\nSnø og is.\r\nSnør...and more = text... \.

Does anyone have some tips to an = solution?

The postgresql version is 7.4.17.

<= /o:p>

------_=_NextPart_001_01CA1429.ABE9747D--