sql - 使用计算的时间戳设置 "VALID UNTIL"值

Question

我想用当前时间计算的时间戳创建用户或更改密码。示例:

# CREATE USER user WITH PASSWORD 'password12345678' VALID UNTIL '(NOW() + interval 1 month)';

当然是无效的:

ERROR: invalid input syntax for type timestamp with time zone: "(NOW() + interval 1 month)"

Answer 1

CREATE USER 等实用命令不接受表达式，只接受文字。您需要动态 SQL。

DO
$do$
BEGIN
   EXECUTE format($$CREATE USER myuser WITH PASSWORD 'password12345678' VALID UNTIL %L$$, NOW() + interval '1 month');
END
$do$;

详细解释:

• Creating user with password from variables in anonymous block