Add Column Postgres Table. To add a not null constraint you need to set default value because When you add new column PostgreSQL takes the NULL as column value for the existing row which violates the NOT NULL constraint. Add one column to a table in PostgreSQL.
ALTER TABLE Book ADD author VARCHAR 50. This is an extension from the SQL standard which does not allow zero-column tables. Up to PostgreSQL 10 when you add a column to table which has a non null default value the whole table needed to be rewritten.
Step 2 From the navigation bar on the left- Click Databases.
Zero-column tables are not in themselves very useful but disallowing them creates odd special cases for ALTER TABLE DROP COLUMN so it seems cleaner to ignore this spec restriction. Constraint specifies the constraint for the new column. Step 4 Click the Execute button. ALTER TABLE Book ADD author VARCHAR 50.
