Postgres COPY FORCE_NOT_NULL option not recognized

Question

I'm trying to import a CSV file into Postgres 9.2 using the COPY command. For all columns, empty strings in the CSV must be interpreted as NULL with the exception of one column.

I believe FORCE_NOT_NULL option is meant to allow this, but when I enter the following command:

COPY migr_escolas  from 'C:\escolas.csv' 
     WITH DELIMITER ',' CSV HEADER FORCE_NOT_NULL;

I get the following message:

ERROR:  syntax error next to "FORCE_NOT_NULL" 
LINE 16: ...om 'C:\escolas.csv' WITH DELIMITER ',' CSV HEADER FORCE_NOT_...

Is FORCE_NOT_NULL really supported? If so what's the syntax?

System Info:

"PostgreSQL 9.2.1, compiled by Visual C++ build 1600, 64-bit"
Windows 7 64 bits

FORCE_NOT_NULL needs a (non empty) comma list of column names after it. It should also be written without the underscores : FORCE NOT NULL col1, col2, ... — joop
– joop, Commented Mar 18, 2014 at 14:33

Grasshopper · Accepted Answer · 2014-03-19 14:07:19Z

9

As pointed by joop's comment above, one should use FORCE NOT NULL and not FORCE_NOT_NULL.

answered Mar 19, 2014 at 14:07

Grasshopper

1,7891 gold badge15 silver badges31 bronze badges

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

Collectives™ on Stack Overflow

Postgres COPY FORCE_NOT_NULL option not recognized

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