How to manage null value while copy data from csv

From: Sachin Kumar <sachinkumaras(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org, krishna(at)thewebconz(dot)com
Subject: How to manage null value while copy data from csv
Date: 2020-12-31 06:25:39
Message-ID: CALg-PKBrp0weDcA_2vsGdd4DCj_jKJy83CYEPyR2+xO2j9jR6A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi experts,

when I am uploading data (CSV File) using the COPY command. I am getting
below mention error.

ERROR: null value in column "adj_type" violates not-null constraint.

When I define null it gives no error message, but how to manage null value
n data without defining it, because there is many more columns. when it
defines null it gives an error if null value comes you are violating null.

Please suggest how to manage null value in postgresql?

--

Best Regards,
Sachin Kumar

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gavan Schneider 2020-12-31 07:59:33 Re: How to manage null value while copy data from csv
Previous Message John Scalia 2020-12-30 21:38:31 Creating a materialized view causing blocks