Question

Error was 'ERROR: value too long for type character varying(50)

  • 26 August 2022
  • 2 replies
  • 45 views

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.


2 replies

Userlevel 2
Badge +12

"but I can’t change it..."

so you must shorten the string with the SubstringExtractor.

Badge +2

@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.

Reply