PostgreSQL: how to wait for password input when running script?

Question

PostgreSQL

Task: ask the user for a password and execute the necessary commands.
Here is my batch file:

@echo on
"C:\Program Files\PostgreSQL\13\bin\psql.exe" -U postgres -f  D:/script.sql -a
pause

If I enter a wrong password, it just goes through the script

. How can I make it wait for the correct password?

Answer 1

First ask for a password in a variable, and then run it by passing the password from the variable.

@echo off
cls
SET /P psqlpassword="Введите пароль (Enter для завершения): "
if "%psqlpassword%"=="" exit /b
"C:\Program Files\PostgreSQL\13\bin\psql.exe" -U postgres -W %psqlpassword% -f  D:/script.sql -a 
pause

If the password is incorrect, an error message will be displayed and execution will continue.
If you need to re-request the password, you should use error checking:

@echo off
:execute_psql
cls
SET /P psqlpassword="Введите пароль (Enter для завершения): "
if "%psqlpassword%"=="" exit /b
"C:\Program Files\PostgreSQL\13\bin\psql.exe" -U postgres -W %psqlpassword% -f  D:/script.sql -a 
if errorlevel 1 goto :execute_psql
pause

True, you need to make sure that psql.exe returns it, which is not a fact. You should also make sure that it does not return errors in other situations when a second password request and start are not required, or enter a check for an error code.

Answer 2

And why do you enter the password with your hands, especially the wrong one? Take it from the pgpass file or just specify it as a PGPASSWORD variable.