Google News
logo
PostgreSQL - Interview Questions
How do we create a column that will default to the current time?
Use CURRENT_TIMESTAMP:

CREATE TABLE tbl_name (a int, modtime TIMESTAMP DEFAULT

CURRENT_TIMESTAMP );
Advertisement