Postgresql: Scripting psql execution with password

postgresql psql

To answer your question, there are several ways provide a password for password-based authentication:

Via the password prompt. Example:

psql -h uta.biocommons.org -U fooPassword for user foo:

In a pgpass file. See libpq-pgpass. Format:

<host>:<port>:<database>:<user>:<password>

With the PGPASSWORD environment variable. See libpq-envars. Example:

export PGPASSWORD=yourpasspsql ...# Or in one line for this invocation only:PGPASSWORD=yourpass psql ...

In the connection string The password and other options may be specified in the connection string/URI. See app-psql. Example:
```
psql postgresql://username:password@dbmaster:5433/mydb?sslmode=require
```

postgresql psql

PGPASSWORD=[your password] psql -Umyuser < myscript.sql

postgresql psql

You can add this command line at the begining of your script:

set PGPASSWORD=[your password]

CodeHunter