From: Blairemaloneback <blairemaloneback@gmail.com>
To: Sachin Kumar <sachinkumaras@gmail.com>
Cc: Pgsql-Admin <pgsql-admin@lists.postgresql.org>
Cc: Pgsql-Admin <pgsql-admin@postgresql.org>
Cc: Krishna <krishna@thewebconz.com>
Subject: Re: How to manage null value while copy data from csv
Date: Mon, 18 Jan 2021 10:40:46 -0500
Message-ID: <3e60e23c-9df4-4143-9cdd-9ecbb410c504@iPhone> (raw)
In-Reply-To: <CALg-PKBrp0weDcA_2vsGdd4DCj_jKJy83CYEPyR2+xO2j9jR6A@mail.gmail.com>
Got it, thanks.
>
> On Dec 31, 2020 at 1:26 AM, <Sachin Kumar (mailto:sachinkumaras@gmail.com)> wrote:
>
>
>
> 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
>
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: blairemaloneback@gmail.com, 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: <3e60e23c-9df4-4143-9cdd-9ecbb410c504@iPhone>
* 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