| From: | Blairemaloneback <blairemaloneback(at)gmail(dot)com> |
|---|---|
| To: | Sachin Kumar <sachinkumaras(at)gmail(dot)com> |
| Cc: | Pgsql-Admin <pgsql-admin(at)lists(dot)postgresql(dot)org>, Pgsql-Admin <pgsql-admin(at)postgresql(dot)org>, Krishna <krishna(at)thewebconz(dot)com> |
| Subject: | Re: How to manage null value while copy data from csv |
| Date: | 2021-01-18 15:40:46 |
| Message-ID: | 3e60e23c-9df4-4143-9cdd-9ecbb410c504@iPhone |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Got it, thanks.
>
> On Dec 31, 2020 at 1:26 AM, <Sachin Kumar (mailto:sachinkumaras(at)gmail(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ankush Chawla | 2021-01-19 03:20:21 | hot standby in Postgresql 12 |
| Previous Message | maicon ferreira da silva | 2021-01-16 03:37:27 |