Good morning,
I’m trying to transfer data from ESRI to PostGis.
Unfortunately, I encounter the following error:
Error was 'ERROR: value too long for type character varying(50)
I understand that the created field is too short but I can’t change it...
Thank you for your help.
"but I can’t change it..."
so you must shorten the string with the SubstringExtractor.
@renaud_nm I agree with @tomfriedl . You'll have to isolate the long text strings by testing the length > 50 and then try and find a pattern to shorten them. Either remove spaces or other none word characters.