I always forget how to do this
Download (right click, save as, rename as appropriate)
1
ALTER TABLE name_of_table ALTER COLUMN "published" SET NOT NULL;