How do I specify a password to ‘psql’ non-interactively?

by

Set the PGPASSWORD environment variable inside the script before calling psql

PGPASSWORD=pass1234 psql -U MyUsername myDatabaseName

For reference, see http://www.postgresql.org/docs/current/static/libpq-envars.html

Edit

Since Postgres 9.2 there is also the option to specify a connection string or URI that can contain the username and password. Syntax is:

$ psql postgresql://[user[:password]@][host][:port][,...][/dbname][?param1=value1&...]

Using that is a security risk because the password is visible in plain text when looking at the command line of a running process e.g. using ps (Linux), ProcessExplorer (Windows) or similar tools, by other users.

See also this question on Database Administrators

More Related Contents:

  1. Run a PostgreSQL .sql file using command line arguments
  2. PostgreSQL “DESCRIBE TABLE”
  3. How to exit from PostgreSQL command line utility: psql
  4. In psql, why do some commands have no effect?
  5. Run batch file with psql command without password
  6. Restore a postgres backup file using the command line?
  7. How to switch databases in psql?
  8. Postgresql: Scripting psql execution with password
  9. “psql: could not connect to server: Connection refused” Error when connecting to remote database
  10. PostgreSQL: encoding problems on Windows when using psql command line utility
  11. psql: FATAL: database “” does not exist
  12. PostgreSQL: Why psql can’t connect to server?
  13. Use variable set by psql meta-command inside of DO block
  14. Alternate output format for psql showing one column per line with column name
  15. Library not loaded: /usr/local/opt/readline/lib/libreadline.6.2.dylib
  16. PostgreSQL disable more output
  17. Shell script to execute pgsql commands in files
  18. Importing .csv with timestamp column (dd.mm.yyyy hh.mm.ss) using psql \copy
  19. Convert hex in text representation to decimal number
  20. SQLAlchemy support of Postgres Schemas
  21. Creating a copy of a database in PostgreSQL
  22. Can’t connect the postgreSQL with psycopg2
  23. How do you change the character encoding of a postgres database?
  24. Difference between GiST and GIN index
  25. How to reload .bash_profile from the command line
  26. Can I use return value of INSERT…RETURNING in another INSERT?
  27. Changing a postgres containers server port in Docker Compose
  28. Import XML files to PostgreSQL
  29. Spring Docker container cannot access Postgres Docker container
  30. PostgreSQL composite primary key

Leave a Comment