| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Rob Sargent <robjsargent(at)gmail(dot)com> |
| Cc: | john polo <jpolo(at)mail(dot)usf(dot)edu>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Find missing data in a column |
| Date: | 2021-12-29 18:16:35 |
| Message-ID: | 90e040af-9f49-5e3e-49e4-2548ad858ba1@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alan Hodgson | 2021-12-29 18:36:43 | Re: Find missing data in a column |
| Previous Message | Rob Sargent | 2021-12-29 18:10:48 | Re: Find missing data in a column |