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
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
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
> 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
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"
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"
On Wednesday, December 29, 2021, john polo wrote:
>
> I understand this means there is a problem with one or more rows in the
> column referenced. This is a column of text. How do I find the error(s) in
> question?
>
It doesn’t actually mean anything…you cannot use the copy command to import
the
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"
--file="C:\Users\Nightrunner\DOCUMEN
