MIME-Version: 1.0
From: Tu Ho <h.diamond084@gmail.com>
Date: Fri, 19 Apr 2024 20:58:25 -0700
Message-ID: <CAMrAN10SpbVB_Y6vwzUWC6Bnd0Y2aoAeGSSjKnHkB0nx7H09Pw@mail.gmail.com>
Subject: [help] Error in database import
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000031e5106167f3880"
Archived-At: <https://www.postgresql.org/message-id/CAMrAN10SpbVB_Y6vwzUWC6Bnd0Y2aoAeGSSjKnHkB0nx7H09Pw%40mail.gmail.com>
Precedence: bulk

--000000000000031e5106167f3880
Content-Type: text/plain; charset="UTF-8"

Hi,

I am currently having a project where I need to combine 2 large database. I
was not however able to import an excel file .csv into the database. The
error was ERROR: syntax error at or near "OIDS" LINE 1: ...ing Site" ,
"International Name(s)" ) FROM STDIN OIDS DELI...
^"

I have no idea how to fix this because I used the "upload file"
option. What should I do?

--000000000000031e5106167f3880
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi,<div><br></div><div>I am currently having a project whe=
re I need to combine 2 large database. I was not however able to import an =
excel file .csv into the database. The error=C2=A0was ERROR: syntax error a=
t or near &quot;OIDS&quot; LINE 1: ...ing Site&quot; , &quot;International =
Name(s)&quot; ) FROM STDIN OIDS DELI...</div>^&quot;<br><div><br></div><div=
>I have no idea how to fix this because I used the &quot;upload file&quot; =
option.=C2=A0What=C2=A0should I do?</div></div>

--000000000000031e5106167f3880--