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'
>>
>>
>>> Cheers,
>>> John
>>
>>
>> --
>> Adrian Klaver
>> adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
--
Adrian Klaver
adrian.klaver@aklaver.com