Re: Find missing data in a column
| От | Adrian Klaver |
|---|---|
| Тема | Re: Find missing data in a column |
| Дата | |
| Msg-id | 90e040af-9f49-5e3e-49e4-2548ad858ba1@aklaver.com обсуждение исходный текст |
| Ответ на | Re: Find missing data in a column (Rob Sargent <robjsargent@gmail.com>) |
| Ответы |
Re: Find missing data in a column
|
| Список | 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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com> > -- Adrian Klaver adrian.klaver@aklaver.com
В списке pgsql-general по дате отправления: