Forum OpenACS Q&A: Re: Technique for adding not null to a column created with alter table

Collapse
2: Re: Technique for adding not null to a column created with alter table (response to 1)
Posted by Jonathan Ellis on 01/16/03 09:44 PM
I've posted this before, but to actually change the table definition rather than adding a separate constraint, do this:

UPDATE pg_attribute SET attnotnull = TRUE
WHERE attname = 'my_column'
  AND attrelid = (SELECT oid FROM pg_class WHERE relname = 'my_table')