Postgres Bulk Loader - Field issue

Question

Hi Team,

I am facing this issue when I try bulk load of data to PostgresSQL

Warning: Output Data (345): 3 Field Names were truncated to fit within the Output Files maximum name length of 75
Error: Output Data (345): Unable to find field "asdasdasdjaskdiuasjhaldshalsdladladasdkahdkahdskahdkahsdkahdkahds" in output record.

Any help here will be appreciated.

The output truncates the field names to 75 chars and the source has 80 characters.

I have done the field mapping in the output but even with that the flow does not work.

Thanks

BrandonB · Answer

I understand that it is automatically truncating to 75 characters but can you try even less than that? A dynamic rename would be the most efficient method of doing so or you could use a select tool to rename. This will help you isolate if these column headers are the issue.

JDong · Answer

Thanks @BrandonB

The output automatically trims the header length, but even on doing that I get the error as shown and data load fails

BrandonB · Answer

https://stackoverflow.com/questions/27865770/how-long-can-postgresql-table-names-be

This is from 2017, so not sure if things have changed since then.