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:53:19 |
Message-ID: | CAGA3vBunshBUDRxZVaKuESm1ittt-rgCNY-_k1a_P7xr1wZRaA@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;
From | Date | Subject | |
---|---|---|---|
Next Message | richard coleman | 2018-08-06 12:59:48 | pgAdmin4 can't handle \'s in data correctly. |
Previous Message | Khushboo Vashi | 2018-08-06 04:04:30 | Re: Where is the server log in pgAdmin v4 |