Intro: THANK YOU - TO ALL OF YOU - for PostgreSQL!
And sorry for having found this small issue .. Topic: CSV import via pgAdmin4 Behaviour due to Docu: http://127.0.0.1:58080/help/help/import_export_data.html?highlight=import Move the Header switch to the Yes position to include the table header with the data rows. If you include the table header, the first row of the file will contain the column names. Bug: No way to avoid first row in csv (UTF-8, Delimiter is ";") to be included in import. (setting switch to "on" and back to "off" didn't help it) Failure report was akin to "imported string to long for target field" . which was true .. string in header row was 6 long, field defined as varchar(2) .. importing ISO language codes. Workaroud: copy of csv file withOUT header-row. Try load --> works perfecty Version: 13, downloaded last Saturday, including pgAdmin, from your website. About pgAdmin4 Version 4.26 Copyright Copyright (C) 2013 - 2020, The pgAdmin Development Team Python Version 3.8.3 (tags/v3.8.3:6f8c832, May 13 2020, 22:37:02) [MSC v.1924 64 bit (AMD64)] Flask Version 1.0.2 Application Mode Desktop Before that, no pg existing on my PC (Windows, current version, auto-updates enabled, Chrome Version 86.0.4240.183 (Offizieller Build) (64-Bit)). Best regards Thomas Merkner Business & Systems Consultant Max-Freygasse 29 A-3400 Klosterneuburg Tel: +43 (0)664 30 27 320 MailTo: <mailto:merk...@aon.at> merk...@aon.at UID: ATU 48161901
