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

##</code><code>##

CREATE TABLE tablename ( ..., ts timestamp DEFAULT CURRENT_TIMESTAMP, ... );