Hi

út 4. 6. 2019 v 10:50 odesílatel <paul.m...@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
>

Reply via email to