Monday, October 19, 2015

How do you run PostgreSQL query on Command Prompt?

@echo off
set REPORTNAME=%1
set timestamp=%date:~-4%%date:~4,2%%date:~7,2%_%time:~0,2%%time:~3,2%%time:~6,2%
set PGPASSWORD=<password>
"C:\Program Files (x86)\pgAdmin III\1.16\psql" -A -h %REPORTNAME% -U <UserName> -d <DatabaseName> -F , --pset footer -c "<Query>" -o "%REPORTNAME%_%timestamp%.csv"