psql \copy

From: <paul(dot)malm(at)lfv(dot)se>
To: <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: psql \copy
Date: 2019-06-04 08:50:16
Message-ID: 785199B14156764C8EB14EF96CEDC44EE02D99@xw-exch03.lfv.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2019-06-04 08:59:48 Re: psql \copy
Previous Message Achilleas Mantzios 2019-06-04 08:04:09 Re: One way replication in PostgreSQL