Select Code to Download

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

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