Re: Find missing data in a column

2021-12-29 Thread john polo
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-pr

Re: Find missing data in a column

2021-12-29 Thread Alan Hodgson
On Wed, 2021-12-29 at 12:43 -0500, john polo wrote: > 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\PostgreSQ

Re: Find missing data in a column

2021-12-29 Thread Adrian Klaver
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_lo

Re: Find missing data in a column

2021-12-29 Thread Rob Sargent
> On Dec 29, 2021, at 10:07 AM, Adrian Klaver wrote: > > On 12/29/21 09:43, john polo wrote: >> 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

Re: Find missing data in a column

2021-12-29 Thread Adrian Klaver
On 12/29/21 09:43, john polo wrote: 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"

Re: Find missing data in a column

2021-12-29 Thread Adrian Klaver
On 12/29/21 09:43, john polo wrote: 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"