Amazon Redshiftにpsqlで接続するときに、psqlのオプションにパスワードの指定オプションがないため、毎回パスワード入力のプロンプトが出てきて面倒な人向け
$ PGPASSWORD=[password] psql -h [Endpoint] -U [username] -d [dbname] -p [port]
More than 5 years have passed since last update.
Redshiftにpsqlのワンライナーで接続したい
Last updated at Posted at 2014-07-30
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme