It appears that pgAdmin4 has trouble properly displaying data that has \'s in it.
For example (using a var char200 field):
in pSQL(and any there else) the field filelocation has this value:
"\\starswirl\Documents\2017\12\19\AD93E646-E5FE-11E7-85AE-EB2E217F96F0.tif"
But in pgAdmin4 it's this:
"\starswirl\Documents 7
9\AD93E646-E5FE-11E7-85AE-EB2E217F96F0.tif"
This is the create script for the database in question:
CREATE DATABASE tms_production
WITH
OWNER = local_user
ENCODING = 'SQL_ASCII'
LC_COLLATE = 'English_United States.1252'
LC_CTYPE = 'English_United States.1252'
TABLESPACE = pg_default
CONNECTION LIMIT = -1;
ALTER DATABASE tms_production
SET default_transaction_read_only TO off;
ALTER DATABASE tms_production
SET client_encoding TO sql_ascii;
ALTER DATABASE tms_production
SET standard_conforming_strings TO off;
