Postgres Pro
Downloads
Home   >   mailing lists

How to manage null value while copy data from csv - Mailing list pgsql-admin

From Sachin Kumar
Subject How to manage null value while copy data from csv
Date
Msg-id CALg-PKBrp0weDcA_2vsGdd4DCj_jKJy83CYEPyR2+xO2j9jR6A@mail.gmail.com
Whole thread Raw
Responses Re: How to manage null value while copy data from csv  ("Gavan Schneider" <list.pg.gavan@pendari.org>)
Re: How to manage null value while copy data from csv  (Blairemaloneback <blairemaloneback@gmail.com>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: John Scalia
Date:
Subject: Creating a materialized view causing blocks
Next
From: "Gavan Schneider"
Date:
Subject: Re: How to manage null value while copy data from csv