[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: Find missing data in a column
From:       john polo <jpolo () mail ! usf ! edu>
Date:       2021-12-30 2:09:24
Message-ID: dedb8532-b29c-8e97-2ce1-400f600b6bd0 () mail ! usf ! edu
[Download RAW message or body]

On 12/29/2021 1:16 PM, Adrian Klaver wrote:
> On 12/29/21 10:10, Rob Sargent wrote:
>>
>>
>
>>> If you want to use psql then:
>>>
>>> pg_dump.exe" 
>>> --file="C:\Users\Nightrunner\DOCUMENTS\programming\pg_out\ebird_sptl_all.txt" 
>>> --host="localhost" --port="5432" --username="postgres" --password 
>>> --no-owner --no-privileges --dbname="ebird_work" 
>>> --table="p_loc.ebd_sptl" --data-only
>>>
>>> psql ebirds
>>>
>>>
>>> \i C:\Users\Nightrunner\DOCUMENTS\programming\pg_out\ebird_sptl_all.txt
>>>
>>
>> Doesn’t that presume OP can connect to linux db from Windows machine? 
>>   Seems the best plan would be copy to; file-tranfer; copy from
>
> Yeah that should been the file location from the OP's COPY command:
>
> '/nt-d/projects_and_data/ebd_OR/ebird_sptl_all.txt'
>
Thanks, everyone, for the replies.

Thanks, Adrian, for the helpful commands you provided. They worked up to 
a point that gave me a different error as the data were loading. I will 
spend some time trying to work that new error out.

Cheers,

John




[prev in list] [next in list] [prev in thread] [next in thread]