Issue migrated from Redmine: https://redmine.postgresql.org/issues/7156
Originally created by ED H at 2022-02-03 18:24:20 UTC.
It is not possible to use the import/export - function provided by pgadmin4 6.4 to import csv data to tables having columns with german umlauts in the column's names.
The error occurs even if the import file is empty, i.e. the error occurs independently of the imported data.
If you create a table like this described by the following create script then importing data leads to this error under WINDOWS 10 (see also attached screenshot):
'ERROR: invalid byte sequence for encoding "UTF8": 0xfc'
CREATE SCRIPT:
CREATE TABLE IF NOT EXISTS public."TableWithUmlautInColumnName"
(
"Hülsenfrüchte" text COLLATE pg_catalog."default"
)
TABLESPACE pg_default;
ALTER TABLE IF EXISTS public."TableWithUmlautInColumnName"
OWNER to postgres;