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

From: richard coleman <rcoleman(dot)ascentgl(at)gmail(dot)com>
To: pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: pgAdmin4 can't handle \'s in data correctly.
Date: 2018-08-06 12:59:48
Message-ID: CAGA3vBusmXLwQfMzxc3erMnU5iRAuPHqLArRsU+zcAdQG9E=kw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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;

Browse pgadmin-support by date

  From Date Subject
Next Message Remund Alain 2018-08-07 07:09:58 column "pid" does not exist
Previous Message richard coleman 2018-08-06 12:53:19 pgAdmin4 can't handle \'s in data correctly.