写一个dat格式文件,内容如下:
@echo off
echo PostgreSQL8.4 Version is starting
echo Please wait ........
cd \
@echo off
REM PostgreSQL server psql runner script for Windows
REM Dave Page, EnterpriseDB
SET server=localhost
SET port=5432
SET username=postgres
SET dbname=wxdch
SET PGPASSWORD=HHXTGLY
SET DbScript=d:\vacuumData.sql
REM Run psql
"e:\database\bin\psql.exe" -U %username% -d %dbname% -a -h %server% -p %port% -w -c "vacuum full verbose;"
pause
本文转自 韬光星夜 51CTO博客,原文链接:http://blog.51cto.com/xfqxj/1344709,如需转载请自行联系原作者