From: | john polo <jpolo(at)mail(dot)usf(dot)edu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Find missing data in a column |
Date: | 2021-12-29 17:43:55 |
Message-ID: | ff98e797-4d49-9ffb-6e60-e9dfdc72cd6f@mail.usf.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I have a database in PostgreSQL 12 on Windows. It has > 8,000,000 rows.
I want to copy this database to PostgreSQL 10 on Slackware Linux. I used
this command to get the data out of the Windows database:
"C:\Program Files\PostgreSQL\12\bin\pg_dump.exe"
--file="C:\Users\Nightrunner\DOCUMENTS\programming\pg_out\ebird_sptl_all.dump"
--host="localhost" --port="5432" --username="postgres" --password
--verbose --format=c --no-owner --no-privileges --dbname="ebird_work"
--table="p_loc.ebd_sptl"
On Slackware, I first:
su postgres
Then try:
psql ebirds
SET SEARCH_PATH TO p_loc;
COPY p_loc.ebird_sptl FROM
'/nt-d/projects_and_data/ebd_OR/ebird_sptl_all.dump';
That fails with
missing data for column "COMMON_NAME"
I understand this means there is a problem with one or more rows in the
column referenced. This is a column of text. How do I find the error(s)
in question?
Cheers,
John
--
Enlightenment is ego's ultimate disappointment.
-Chogyam Trungpa
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2021-12-29 17:54:49 | Find missing data in a column |
Previous Message | Avi Weinberg | 2021-12-29 12:39:14 | Initial Sync - One Subscriber After The Other vs. Parallel |