Cannot \copy into postgresql table which has default clock_timestamp

Question

My table has a NOT NULL column called 'created' with DEFAULT CLOCK_TIMESTAMP(). My CSV file from which I am copying intentionally does not have a column called 'created' because I want the database to use the default value for it. My copy command is:

\copy table_name from '/local/path/to/file.csv' delimiter ',' CSV HEADER

The error I receive is:

missing data for column "created_"

The PostgreSQL documentation says: "If there are any columns in the table that are not in the column list, COPY FROM will insert the default values for those columns."

Thanks for any help

user330315 · Accepted Answer · 2016-10-07 12:54:24Z

10

The clue is in the "that are not in the column list".

You need to specify the "column list" for this to work and leave out the one with the default value:

\copy table_name (column1, column2, ...) from '/local/path/to/file.csv' delimiter ',' CSV HEADER

answered Oct 7, 2016 at 12:54

user330315

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

1 Comment

SplendidSplinter Over a year ago

That did the trick - I thought the HEADER keyword just told it to use the CSV header columns as my list. Maybe I'll send a documentation clarification request...

Collectives™ on Stack Overflow

Cannot \copy into postgresql table which has default clock_timestamp

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related