From: Gavan Schneider <list.pg.gavan@pendari.org>
To: Sachin Kumar <sachinkumaras@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Cc: pgsql-admin@postgresql.org
Cc: krishna@thewebconz.com
Subject: Re: How to manage null value while copy data from csv
Date: Thu, 31 Dec 2020 18:59:33 +1100
Message-ID: <95624F2E-5D82-4B3B-BC0A-B20F3DCC5150@pendari.org> (raw)
In-Reply-To: <CALg-PKBrp0weDcA_2vsGdd4DCj_jKJy83CYEPyR2+xO2j9jR6A@mail.gmail.com>
References: <CALg-PKBrp0weDcA_2vsGdd4DCj_jKJy83CYEPyR2+xO2j9jR6A@mail.gmail.com>
On 31 Dec 2020, at 17:25, Sachin Kumar wrote:
> 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.
>
This indicates the relevant column in the database table has been
defined to **never** allow a NULL value.
> 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.
>
What is meant by “define null”? Is this where you put a real value
in the CSV, or a dummy text value such as “null”?
You could massage the csv so all the gaps get a dummy value, then handle
this in the SQL table.
Otherwise
> Please suggest how to manage null value in postgresql?
>
Basic options
1. Fix the raw csv data so there are no gaps — the person who defined
the database wasn’t expecting any
2. Fix the database so it will accept NULL values — assuming this is
ok with the business model
3. Accept the csv data into a temporary table which tolerates NULL,
massage the data then insert into the real database
Regards
Gavan Schneider
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: list.pg.gavan@pendari.org, sachinkumaras@gmail.com, pgsql-admin@lists.postgresql.org, krishna@thewebconz.com
Subject: Re: How to manage null value while copy data from csv
In-Reply-To: <95624F2E-5D82-4B3B-BC0A-B20F3DCC5150@pendari.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox