Re: pgAdmin4 not handling '\' characters properly

Wondering if this is a character set issue with your data? If you look at the rows as shown in DBeaver or psql, the back slash "\" following the word "Documents" in the file path appears the same for the first four result rows from 2017 and the following rows from 2018. However the odd looking character that shows in this same position in pdadmin seems to differ (assuming it's byte pairs?). Looks like this might be a character set / encoding issue. I believe database client encoding is set by default to follow database encoding -- psql sets client encoding to auto, following locale settings from your terminal -- or, apparently, you can override this as needed (pgclientencoding). Depending on how the data got into your system, I wonder if you may have differing encoding from different sources, and whatever encoding pgadmin (and/or your client connection is set to when using pgadmin) is using a different encoding interpretation than DBeaver and psql.