There are two ways to non interactively provide a password for the psql command (PostgreSQL interactive terminal). Each method allows you to quickly write shell scripts using terminal-based PostgreSQL utilities as you can provide user credentials from the password file or environment variables. Provide password using the password file To use this method, create .pgpass … Continue reading How to non interactively provide password for the PostgreSQL interactive terminal