Re: [Treebase-devel] db2->pg data transfer

[Mark D. <mj...@ge...>]

On Wed, 2009-05-27 at 14:28 -0400, Hilmar Lapp wrote:
> How does the IXF format look like? Is it text-based?

It's a binary format.  I have attached an IXF dump of the USERROLE
table, whose contents are as follows:

AUTHORITY        | USERROLE_ID | VERSION
----------------------------------------
User             | 2           | 1      
Associate Editor | 3           | 1      
TEST             | 4           | 0      
Admin            | 1           | 1      
TEST             | 24          | 0      
TEST             | 25          | 0      


> PostgreSQL  
> supports delimited files for import in various formats)

DB2 will dump a delimited file or a CSV file, but it truncates the data
to 250 characters.