@echo off
set pgpassword=
set hostname=
set dbuser=
set dbname=
set out_dir=d:\1
set time=to_timestamp('2000-12-01 10:00:00','yyyy-mm-dd hh24:mi:ss')
psql -h %hostname% -U %dbuser% -c "select * from ad_client where ad_client_id = 0 and updated >to_timestamp('2000-12-01
10:00:00','yyyy-mm-dd hh24:mi:ss')" %dbname% >%out_dir%\ad_client.sql
pause
需要导出的表名称:
"a_asset_spread"
"ad_alert"
"ad_alertprocessor"
"ad_alertprocessorlog"
"ad_alertrecipient"
"ad_alertrule"
"ad_changelog"
因为要导出的表比较多,所以将psql。。。。语句写很多条太麻烦,请大神指点,能不能用变量的方式执行个循环呢?