postgresql字段默认设置当前时间

CREATE TABLE "public"."my_pg_table" (
	"id" BIGSERIAL NOT NULL,
	"content" VARCHAR NULL DEFAULT NULL,
	"yesterday" DATE NOT NULL DEFAULT DATE(TIMEZONE('UTC-8'::TEXT, NOW())) - INTEGER '1',
	"ts" TIMESTAMP NOT NULL DEFAULT TIMEZONE('UTC-8'::TEXT, NOW()::TIMESTAMP(0) WITHOUT TIME ZONE),
	PRIMARY KEY ("id")
)
;
posted @   CrossPython  阅读(5027)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示