I have a table that was created with pgAdmin4 (12.0) on Windows 10. I used the following to dump the data to a file.

```
"C:\Program Files\PostgreSQL\12\bin\pg_dump.exe" --data-only 
--file="C:\\Users\\ciris\\DOCUMENTS\\programming\\pg_out\\test.sql" 
--host="localhost" --port="5432" --username="postgres" --password --verbose
--format=p --no-owner --no-privileges --table="pc.ebd_sel_pt" "ebird_work"

```

The dump file is ~2GB. I want to take the dump file, test.sql, and recreate the table on a linux Postgresql db. I created the db in psql (v10) on linux with:

```
CREATE TABLE ebc.eb_sel (
global_unique_identifier VARCHAR,
common_name VARCHAR,              
scientific_name VARCHAR,
observation_count VARCHAR, 
state_province VARCHAR,
county VARCHAR,
locality VARCHAR,
longitude NUMERIC(8,5),        
latitude NUMERIC(8,5),       
observation_date DATE,        
time_observations_started VARCHAR,
first_name VARCHAR,
last_name VARCHAR,       
protocol_type VARCHAR,
all_species_reported INTEGER,
sampling_event_identifier VARCHAR,
obs_time TIMESTAMP,
point INTEGER);        

```

To import the data to the linux version of the table that was created in Windows, I used the following:

```
\COPY ebc.eb_sel 
FROM '/d/data/linux/pgsql/data/dat1/test.sql' 
WITH DELIMITER ',' CSV HEADER;

```

I get an error in psql that says,

```
2020-08-08 07:33:12.005 EDT [2297] ERROR:  missing data for column "common_name"
2020-08-08 07:33:12.005 EDT [2297] CONTEXT:  COPY eb_sel, line 2: "-- PostgreSQL database dump"
2020-08-08 07:33:12.005 EDT [2297] STATEMENT:  COPY  ebc.eb_sel FROM STDIN WITH DELIMITER ',' CSV HEADER;
ERROR:  missing data for column "common_name"
CONTEXT:  COPY eb_sel, line 2: "-- PostgreSQL database dump"

```

What is causing this error?

EDIT- after the suggestion from @GiuseppeSchembri that my pg\_dump statement was wrong, I rewrote part of it. Now it is:

```
"C:\Program Files\PostgreSQL\12\bin\pg_dump.exe" --data-only 
--file="C:\\Users\\ciris\\DOCUMENTS\\programming\\pg_out\\test.sql" 
--host="localhost" --port="5432" --username="postgres" --password 
--verbose --format=p --no-owner --no-privileges --dbname="ebird_work" 
--table="pc.ebd_sel_pt"

```

More specifically, I changed `--table="pc.ebd_sel_pt" "ebird_work"` to `--dbname="ebird_work" --table="pc.ebd_sel_pt."` As I replied directly to @GiuseppeSchembri below, the db is "ebird\_work", the schema is "pc", and the table is "ebd\_sel\_pt".

I made a new dump file with that command. I tried the same \COPY statement and I get the same error. I dropped the table I made and remade it with all of the column names in all capitals (I think the original table was all in caps).