一、当前时间加上某些天数
(now() + '365 days'::interval)
二、使用序列
1，序列写法
-- Sequence: memberaccount_cardautono -- DROP SEQUENCE memberaccount_cardautono; CREATE SEQUENCE memberaccount_cardautono INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; ALTER TABLE memberaccount_cardautono OWNER TO admin;
2，默认值写法
nextval('memberaccount_cardautono'::regclass) 原文链接：https://www.f2er.com/postgresql/195962.html