| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | paul(dot)malm(at)lfv(dot)se |
| Cc: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: psql \copy |
| Date: | 2019-06-04 08:59:48 |
| Message-ID: | CAFj8pRCqZGvfBewOJ5mOhNSR4C00gecrNb8ef=A_koCPzqAhLA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi
út 4. 6. 2019 v 10:50 odesílatel <paul(dot)malm(at)lfv(dot)se> napsal:
> Hi. I’m trying to execute this command:
>
> C:\P_bin\psql -h 10.233.37.24 -p 5432 -U tester -d test -w -c "\copy
> public.BadenWuerttemberg_20181011 FROM C:\data\Baden-Wuerttemberg.csv' WITH
> DELIMITER ';' CSV"
>
> Error: relation "public.badenwuerttemberg_20181011" does not exist.
>
> What am I Doing wrong?
>
looks like case sensitive identifier is used. try
"\copy public.""BadenWuerttemberg_20181011"" ...
Regards
Pavel Stehule
>
> There is a table (badenwuerttemberg_20181011) in database test under the
> public schema. The table has all the columns, with the right types, as the
> csv-file.
>
> I’m using PostgreSQL 11
>
> Kind regards,
>
> Paul
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matteo Beccati | 2019-06-04 09:00:39 | Research on ?? operators |
| Previous Message | paul.malm | 2019-06-04 08:50:16 | psql \copy |