What's the quickest way to periodically export PostgreSQL data to a local file on Windows?
Install the psql client (I believe it's in the pgAdmin III install). Add it to your PATH.
Put the following in %appdata%\postgresql\pgpass.conf (you may need to create that file):
hostname:port:database:username:password
In cmd:
psql -c &quot;\copy (select * from foo) to 'fooLocal.txt';&quot; --host $hostname --dbname $dbname --user $username 
then fooLocal.txt will be a tab-delimited representation of the output of your query.
\copy (as opposed to COPY) can copy data from a remote server and doesn't need superuser privileges.
If you want to run that psql command on a schedule, you can use Task Scheduler (GUI) or schtasks (CLI), which is somewhat like cron for Windows.