How to manage null value while copy data from csv

Поиск
Список
Период
Сортировка
Искать
От
Sachin Kumar
Тема
How to manage null value while copy data from csv
Дата
Msg-id
CALg-PKBrp0weDcA_2vsGdd4DCj_jKJy83CYEPyR2+xO2j9jR6A@mail.gmail.com
Список
Дерево обсуждения
How to manage null value while copy data from csv Sachin Kumar <sachinkumaras@gmail.com>
Re: How to manage null value while copy data from csv Blairemaloneback <blairemaloneback@gmail.com>
Re: How to manage null value while copy data from csv "Gavan Schneider" <list.pg.gavan@pendari.org>
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 по дате отправления
От: John Scalia
Дата:
От: Gavan Schneider
Дата:
FAQ