Answer

问题及解答

更改 PostgreSql 数据库中某个表的时间属性并设置默认值

Posted by haifeng on 2015-05-11 20:46:46 last update 2015-05-12 15:35:41 | Edit | Answers (0)


ALTER TABLE questions ALTER COLUMN postDate TYPE timestamp(0) without time zone ;

ALTER TABLE questions ALTER COLUMN postDate SET DEFAULT current_timestamp ;