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

From: "Thomas Merkner" <merkner(at)aon(dot)at>
To: <pgadmin-hackers(at)postgresql(dot)org>
Subject: BUG (small): Import CSV via pgAdmin4 does always try to load header row
Date: 2020-11-09 22:27:58
Message-ID: 000f01d6b6e7$94758a40$bd609ec0$@aon.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

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:merkner(at)aon(dot)at> merkner(at)aon(dot)at
UID: ATU 48161901

Browse pgadmin-hackers by date

  From Date Subject
Next Message Rahul Shirsat 2020-11-10 08:29:32 Re: SonarQube Fixes #3
Previous Message Akshay Joshi 2020-11-09 16:01:16 Re: pgadmin