POSTGRES: Add or delete columns

-- Delete a column (id)

ALTER TABLE substance DROP id;


-- Add new column (id as Primary Key)

ALTER TABLE substances ADD COLUMN id INTEGER PRIMARY KEY;

-- Note: Column order can NOT be changed.