Non null constraint error on populating postgres table column from CSV

Question

I want to populate one column in a postgres table from a CSV file.

I am trying this command in postgres 9.5.5 -

\copy myschema.items(name) from items.csv;

and get this error -

ERROR: null value in column "item_code" violates not-null constraint DETAIL: Failing row contains..... CONTEXT: COPY items, line 1: "some value"

Is postgres trying to populate all columns from the CSV and complains because it does not find ones with non null constraints in the CSV? How do I tell postgres not to worry about other columns and instead just copy the name column stated in the command into the table?

Laurenz Albe · Accepted Answer · 2017-10-29 18:56:39Z

2

Two errors there:

Put the file name in single quotes.
Add (FORMAT 'csv')

answered Oct 29, 2017 at 18:56

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Non null constraint error on populating postgres table column from CSV

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related