public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrian Klaver <[email protected]>
To: Tu Ho <[email protected]>
To: [email protected]
Subject: Re: [help] Error in database import
Date: Fri, 19 Apr 2024 21:27:41 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAMrAN10SpbVB_Y6vwzUWC6Bnd0Y2aoAeGSSjKnHkB0nx7H09Pw@mail.gmail.com>
References: <CAMrAN10SpbVB_Y6vwzUWC6Bnd0Y2aoAeGSSjKnHkB0nx7H09Pw@mail.gmail.com>
On 4/19/24 20:58, Tu Ho wrote:
> 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
There are Excel files(.xls/.xlsx) and there are *.csv files.
> 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?
Use a recent version of whatever client you are using as:
https://www.postgresql.org/docs/current/sql-copy.html
"If 1, OIDs are included in the data; if 0, not. Oid system columns are
not supported in PostgreSQL anymore, but the format still contains the
indicator."
Your client is using old syntax as the last version of Postgres that
allowed FROM STDIN OIDS was:
https://www.postgresql.org/docs/11/sql-copy.html
"where option can be one of:
FORMAT format_name
OIDS [ boolean ]
"
And Postgres 11 is ~6 months past EOL.
--
Adrian Klaver
[email protected]
view thread (2+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: [help] Error in database import
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox