Dump from cygwin directly to windows - Mailing list pgsql-hackers

From Mike G.
Subject Dump from cygwin directly to windows
Date
Msg-id 20041217225647.GA14073@localhost.localdomain
Whole thread Raw
Responses Re: Dump from cygwin directly to windows
List pgsql-hackers
Hello,

In testing RC1 today I attempted to use pg_dump -h cygwin_box mydb | psql -h RC1_box mydb

It started off ok but at somepoint while transferring data over in a table it went astray.  I started getting rows and
rowsof syntax errors most of them saying "invalid command \N".  
 

All of the functions, views, and table definitions transferred successfully but none of the data in the tables did.

I swear I did this in an earlier beta version and it worked.

I don't see any option in pg_dump to specify options for the Copy commands issued.  

Using the pg_dump as insert statements option seems to be working fine.

Not sure if this would be considered a bug or new feature.

Mike




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Permissions within a function
Next
From: Sean Chittenden
Date:
Subject: pgmemcache 1.0rc1...