Re: EXPLAIN ANALYZE in batch file

just make a text file with the sql commands in it.
end each command with a ;
the make a scheduled job that executes the program psql, taking the commands from the file.

so, i make text file calles test.sql. the contents are:
vacuum analyze;
create table test as select 'hello world'::text;
--the end

then make a scheduled job that executes this command:
psql -f test.sql -U itsme postgres
(psql is the command line client for postgresql, manual here: http://www.postgresql.org/docs/9.1/static/app-psql.html)

It would ask for a password, so you need to create a way to allow the script to run without you typing the password.
i use peer authentication, but that is not supported in windows.
you could use the password file for that:
On Microsoft Windows the file is named %APPDATA%\postgresql\pgpass.conf (where %APPDATA% refers to the Application Data subdirectory in the user's profile).
It should look like this:

hostname:port:database:username:password

so for example:
localhost:5432:postgres:itsme:secret

HTH

WBL




--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth