@echo off
chcp 1252
:: Database password needs to be set globally
set PGPASSWORD=<YOUR-PASSWORD>
SETLOCAL
set USER=postgres
set HOST=localhost
set DBNAME=my-database
:: Invoking postgres assuming that PSQL is on system path
psql -h %HOST% -U %USER% %DBNAME%
ENDLOCAL