I’m currently facing an issue while attempting to load two tables, namely concept_synonym and concept, from Athenn in bulk using the default pgAdmin data loader. Specifically, I’m encountering a “character too long” error, and I’m seeking your guidance and expertise to overcome this obstacle. Allow me to provide more details about the problem I’m experiencing.
When trying to load the mentioned tables, it appears that some data (maybe from some dictionaries) within them are not separated by tabs (\t) as expected. As a result, the data loader is throwing a “character too long” error, indicating that the character length exceeds the maximum limit allowed.
I have conducted some initial research and investigation on my own, but I haven’t been able to find a suitable solution yet. Therefore, I’m turning to this knowledgeable and supportive community for any advice, insights, or alternative approaches you might have.