@echo off
set PGPORT=5432
set PGHOST=localhost
set PGUSER=postgres
set PGPASSWORD=M1w8vGt8esLhix7Y
set THEDB=test
set PGBIN="C:\Program Files\PostgreSQL\13\bin\psql"
%PGBIN% -c "UPDATE config_sign_archive SET archive_day = CASE WHEN EXTRACT(DAY FROM CURRENT_DATE) < 15 THEN EXTRACT(DAY FROM CURRENT_DATE) + EXTRACT(DAY FROM (DATE_TRUNC('MONTH', CURRENT_DATE) - INTERVAL '1 DAY')) ELSE EXTRACT(DAY FROM CURRENT_DATE) - 1 END;" -d "%THEDB%"
echo update config_sign_archive successfully.
pause
pg数据库windows执行语句
最新推荐文章于 2024-07-26 14:20:58 发布