PostgreSQL: non-interactive input password

1. ~/.pgpass
   

   hostname:port:database:username:password

   chmod 0600 ~/.pgpass

    

2. PGPASSWORD=password psql  --host=host --port=5432 --username postgres postgres