ALTER TABLE tablename ADD COLUMN ts timestamp;
ALTER TABLE tablename ALTER COLUMN ts SET DEFAULT CURRENT_TIMESTAMP;