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
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 |