| From: | ourdiaspora <ourdiaspora(at)protonmail(dot)com> |
|---|---|
| To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: csv copy error |
| Date: | 2021-12-31 10:03:54 |
| Message-ID: | ErlPDvE1ztJUi8lRrFzTU-POEnxuDVd4WcZdh0_lkBY-A0jUzS0Ou5h1-Gk06sI6lGGs0IUxjUSJuS9x5itZANpnjwq9zgsGGdvpQoQV5lo=@protonmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thursday, December 30th, 2021 at 7:30 AM, Guillaume Lelarge <guillaume(at)lelarge(dot)info> wrote:
> Hi,
>
> Le mer. 29 déc. 2021 à 22:08, ourdiaspora <ourdiaspora(at)protonmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ourdiaspora | 2021-12-31 13:12:02 | create query with date values |
| Previous Message | Hasan Marzooq | 2021-12-31 02:32:41 | Re: pg_config header files are missing - Postgres 13 - Amazon Linux 2 |