Re: Importing directly from BCP files - Mailing list pgsql-general

From Tim Uckun
Subject Re: Importing directly from BCP files
Date
Msg-id CAGuHJrOz5p1Mu-rZYc-nJR1ifYJqZgEgqx5sDg2K19=n-OrD2Q@mail.gmail.com
Whole thread Raw
In response to Re: Importing directly from BCP files  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Importing directly from BCP files  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
the binary form of the BCP file output is undocumented. So if all the BCP files you have are the binary(native) version you are up this creek without a paddle.


Ugh.  Yes it looks like that's the creek I am on.   Thanks Microsoft!
 
So, moving to another creek. It depends on the amount of data you are working with, but it might be worth it to spin up a VM in the cloud on AWS, Azure, etc that has SQL Server on it and import the BCP files there. You could then export the data using the character format instead of the native format:

Man that really sucks but if it's the only way then I guess it's the only way.
 

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Importing directly from BCP files
Next
From: Michael Paquier
Date:
Subject: Re: Adding a new module to postgres