How to Add a Column

In Postgres (as in many other SQL databases), in order to add a column you need to use an alter table like the following:

alter table employee add column last_bonus_date date;

The value of the new column will be NULL for all the existing rows in the table.

IN THIS PAGE