PostgreSQL, about FORCE NOT NULL

Question

I have an issue using FORCE NOT NULL in PostgreSQL.

I have a table with 10 columns and I need to load data to it from a CSV file.

I'm using the following query, which works perfectly:

COPY "myschema"."mytable" 
FROM '/var/www/myapp/myfile.csv' 
DELIMITERS '|' 
CSV 
FORCE NOT NULL 
attr1, attr2, attr3, attr4, attr5, attr6, attr7, attr8, attr9, attr10;

I need to know how to do this without explicitly coping all the columns as arguments to the FORCE NOT NULL because I have more tables with hundreds of columns that require this.

I tried FORCE NOT NULL *, FORCE NOT NULL * but the query returns an error. I can't find a solution to this on the Internet.

Thanks in advance for the help you can provide me!

You forgot to mention your version of PostgreSQL.

Erwin Brandstetter
– Erwin Brandstetter

2012-12-30 17:07:45 +00:00
Commented Dec 30, 2012 at 17:07 — Erwin Brandstetter
– Erwin Brandstetter, Commented Dec 30, 2012 at 17:07

Trent Earl · Accepted Answer · 2012-12-30 15:42:49Z

1

FORCE NOT NULL * is not valid postgresql. A patch for this was almost passed but rejected. Read this mailing list for the discussion.

answered Dec 30, 2012 at 15:42

Trent Earl

3,6671 gold badge18 silver badges20 bronze badges

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

1 Comment

vjfn1990 Over a year ago

I read the mailing list. It's seem not to be solution for what i need to do. Thanks for the help. =(

Collectives™ on Stack Overflow

PostgreSQL, about FORCE NOT NULL

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