Import CSV file, empty string are managed as empty string in column instead of NULL after upgrade 8.13

[pentolone]

Importing csv file with empty string risult in empty string in table too.

To Reproduce

1. Create table with 1 TEXT column,
2. Create csv file (comma separated) with empty string like ,,
3. Click on import
4. Verify that the column in table has empty string insetad of NULL.

Expected behavior

Empty string stored as NULL value in table columns

[pentolone]

database server version 15

[adityatoshniwal]

@pentolone
Below is what we've tried and the output from the table. If you're using quotes then it will be considered as empty string. Blank is take as NULL.

[pentolone]

Thank for the answer, but we have null values NOT at the end of line, but in the middle.
Something like

adi,,last

Result in table should be adi|null|last but we have adi||last

[adityatoshniwal]

@pentolone It doesn't matter where the position is, its working fine:

[pentolone]

I tested again just now, we are using pgadmin4 in server mode.

This is the example, I used pgadmin4 interface Import/Export options without changing anything but the column separator

itemcode,unitload,lotto,datascadenza,dataproduzione,qty,aqty,scaffale
202117,MF0131736,AB245BL0724,01/06/2026,,200,,M1BU00000002

This is the result

[adityatoshniwal]

@pentolone I tested for on pgAdmin v8.13. What is the version you're using?
Also, can you share the table ddl please?

[pentolone]

Hi, these are details:

Version: 8.13
Commit: b278265 2024-11-11
Application Mode: Server
Operating System: Alpine Linux v3.20, Linux-5.10.0-23-amd64-x86_64-with