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: merkner@aon.at
UID: ATU 48161901