Thread: CSV file import issue

CSV file import issue

From
Saroj Dora
Date:
Dear Team,

Unable to import CSV file in my local desk it is showing error please find the issue and update how I will be use better way to import. i tried both way through query and select file.





Attachment

Re: CSV file import issue

From
Aditya Toshniwal
Date:
Hi Saroj,

The process logs clearly show what the error is. My guess is - you're uploading with DD-MM-YYYY format but PostgreSQL server reads it as MM-DD-YYYY format. And so - out of range error.

On Mon, Jun 16, 2025 at 4:55 PM Saroj Dora <dorasaroja32@outlook.com> wrote:
Dear Team,

Unable to import CSV file in my local desk it is showing error please find the issue and update how I will be use better way to import. i tried both way through query and select file.







--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Staff SDE II | enterprisedb.com
"Don't Complain about Heat, Plant a TREE"
Attachment