Re: [mdb-dev] Command line option to suppress binary data

[Nirgal <con...@ni...>]

I added a simmilar option in repository last Sunday (!)

Source is available at:
https://github.com/brianb/mdbtools/archive/master.tar.gz

You can now use -b strip to remove the binary data.

Also, I could export the binary data into a postgres database using octal encoding, with new option -b octal.
I then used psql COPY command to import the data, but somehow, I had to replace \ by \\ in the csv file first (sed -e s/\\/\\\\/g)

See existing bug repport at:
https://github.com/brianb/mdbtools/issues/16
https://bugs.launchpad.net/ubuntu/+source/mdbtools/+bug/390730

Cheers

On Monday 03 December 2012 17:15:35 Alfonso Muñoz-Pomer Fuentes wrote:
> Hi again.
> 
> In the database we’re migrating from Access to PostgreSQL we have some 
> fields which contain binary data. They’re used for replication so they 
> can be safely ignored for the migration process. The issue is that there 
> are certain rows in which these binary fields may contain escape 
> sequences which break the import to PostgreSQL. I’ve added a command 
> line option (-B) to skip binary data with blank fields.
> 
> I don’t know if this is a known issue and if such a workaround would be 
> welcome.
> 
>