Re: psql \copy
| От | Pavel Stehule |
|---|---|
| Тема | Re: psql \copy |
| Дата | |
| Msg-id | CAFj8pRCqZGvfBewOJ5mOhNSR4C00gecrNb8ef=A_koCPzqAhLA@mail.gmail.com обсуждение исходный текст |
| Ответ на | psql \copy (<paul.malm@lfv.se>) |
| Ответы |
Re: psql \copy
|
| Список | pgsql-general |
Hi
út 4. 6. 2019 v 10:50 odesílatel <paul.malm@lfv.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
В списке pgsql-general по дате отправления: