How to set not null constraint to columns in postgres

Question

I tried to set null to columns like following.

ALTER TABLE myschema.table ALTER COLUMN (test_id,type) SET NOT NULL;

But it returned syntax error like Syntax error at or near Line 3, Position 47

Are there any proper way to achieve this ?

If someone has opinion please let me know.

Thanks

Does this answer your question? Change column type and set not null — Stalinko
– Stalinko, Commented Jun 3, 2021 at 6:13

user330315 · Accepted Answer · 2021-06-03 06:30:05Z

18

You can't provide a list of column in parentheses, you need to use multiple ALTER COLUMN options separated by a comma:

ALTER TABLE the_table
    ALTER COLUMN test_id set not null, 
    ALTER COLUMN type SET NOT NULL;

answered Jun 3, 2021 at 6:30

user330315

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

Comments

Slava Rozhnev · Accepted Answer · 2021-06-03 07:18:19Z

7

Try doing it separately for both the columns:

ALTER TABLE myschema.table ALTER COLUMN test_id SET NOT NULL;

ALTER TABLE myschema.table ALTER COLUMN type SET NOT NULL;

Slava Rozhnev

10.2k6 gold badges27 silver badges43 bronze badges

answered Jun 3, 2021 at 6:01

Ria Kalia

713 bronze badges