Create shelf(id int PK, label text NOT NULL), ALTER it to ADD COLUMN capacity int DEFAULT 100, insert (1,'A1'), and RETURN all columns.
Create shelf(id int PK, label text NOT NULL), ALTER it to ADD COLUMN capacity int DEFAULT 100, insert (1,'A1'), and RETURN all columns.
Answer
CREATE TABLE shelf (id int PRIMARY KEY, label text NOT NULL); ALTER TABLE shelf ADD COLUMN capacity int DEFAULT 100; INSERT INTO shelf (id, label) VALUES (1, 'A1') RETURNING *;