How to handle SERIAL column while using Postgres Bulk Load Snap

[aprabhav]

I am trying to use a Postgres Bulk Load snap. But my table has a serial column (viz. id). I tried a couple of things but the postgres bulk load snap fails due to various errors as my input data does not have id column. I was expecting that the snap would behave like the postgres copy command. I would like to know how others have used postgres bulk load snap in such cases.

[aprabhav]

Thanks Pero for your helpful suggestions.

It should not be required to add the serial column data in the input document.

I was able to fix this problem by doing the following…

1. specified the list of columns (excluding the serial id column) in the Columns list in the snap
2. used ‘Text’ option for the format field in the snap
3. unchecked ‘Header provided’ field in the snap.