Thread: BUG (small): Import CSV via pgAdmin4 does always try to load header row

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