How do I an add a DEFAULT on a column if the table already exists?
In PostgreSQL, DEFAULT is not a constraint. PostgreSQL follows the spec and implements the &lt;set column default clause&gt;. See the ALTER TABLE command documentation for more details. Your command should look like this:

ALTER TABLE foo
  ALTER COLUMN column_name
  SET DEFAULT now();