pgAdmin4 can't handle \'s in data correctly.

[richard coleman]

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;