Postgres Pro
Downloads
Home   >   mailing lists

Re: psql \copy - Mailing list pgsql-general

From Pavel Stehule
Subject Re: psql \copy
Date
Msg-id CAFj8pRCqZGvfBewOJ5mOhNSR4C00gecrNb8ef=A_koCPzqAhLA@mail.gmail.com
Whole thread Raw
In response to psql \copy  (<paul.malm@lfv.se>)
Responses Re: psql \copy
List pgsql-general
Tree view
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 by date:

Previous
From:
Date:
Subject: psql \copy
Next
From: Matteo Beccati
Date:
Subject: Research on ?? operators