Re: csv copy error - Mailing list pgsql-general

From ourdiaspora
Subject Re: csv copy error
Date
Msg-id ErlPDvE1ztJUi8lRrFzTU-POEnxuDVd4WcZdh0_lkBY-A0jUzS0Ou5h1-Gk06sI6lGGs0IUxjUSJuS9x5itZANpnjwq9zgsGGdvpQoQV5lo=@protonmail.com
Whole thread Raw
In response to Re: csv copy error  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgsql-general
On Thursday, December 30th, 2021 at 7:30 AM, Guillaume Lelarge <guillaume@lelarge.info> wrote:

> Hi,
>
> Le mer. 29 déc. 2021 à 22:08, ourdiaspora <ourdiaspora@protonmail.com> a écrit :
>
> >
> > \copy exampletable from '/local/path/to/examplefile.csv';
> >
>
> You should tell the CSV command you're using a CSV file. By default, COPY thinks it's a TSV file.
>

Problem solved with:

"
...file.csv' with csv;
"

Thanks to all.




pgsql-general by date:

Previous
From: Hasan Marzooq
Date:
Subject: Re: pg_config header files are missing - Postgres 13 - Amazon Linux 2
Next
From: ourdiaspora
Date:
Subject: create query with date values