Problems when copy data from dump file - Mailing list pgsql-sql

From Klas Stockhem
Subject Problems when copy data from dump file
Date
Msg-id 2A250781A3744D48B1529FCC3C2EB8ABCB4684@comserver.benders.se
Whole thread Raw
List pgsql-sql
<div class="Section1"><p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:
12.0pt"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US" style="font-size:
10.0pt;font-family:Arial">I get an error when I’m trying to fill my table with data. I have a postgresql dump file and
copy-pastethe text from the file into my webbased phppgadmin interface. I have created my tables
correctly.</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span lang="EN-US" style="font-size: 
10.0pt;font-family:Arial">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.</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span lang="EN-US" style="font-size: 
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US"
style="font-size:
10.0pt;font-family:Arial">SQL error:</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US"
style="font-size:
10.0pt;font-family:Arial">ERROR:  syntax error at or near "5"</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial">LINE 2: 5 Slitasje og vedlikehold PRAKTISKE OPPLYSNINGER\r\n\r\nSn&#...</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">        ^</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">COPY artikkel (id, tittel, tekst) FROM stdin;</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial">5                    Slitasje og vedlikehold            PRAKTISKE OPPLYSNINGER\r\n\r\nSn&#248;
ogis.\r\nSn&#248;r...and more text... \.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US" style="font-size:
10.0pt;font-family:Arial">Does anyone have some tips to an solution?</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span lang="EN-US" style="font-size: 
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US"
style="font-size:
10.0pt;font-family:Arial">The postgresql version is </span></font><span class="platform">7.4.17.</span><font
face="Arial"size="2"><span lang="EN-US" style="font-size:10.0pt;font-family:Arial"></span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span lang="EN-US" style="font-size: 
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font color="#a6a6a6" face="Verdana" size="2"><span
lang="EN-US"style="font-size:10.0pt;font-family:Verdana;color:#A6A6A6"> </span></font></div> 

pgsql-sql by date:

Previous
From: Axe
Date:
Subject: Re: Tweak sql result set... ?
Next
From: "Klas Stockhem"
Date:
Subject: Problems when copy data from dump file