Redshift is a data warehouse platform from AWS. Since its built over PostgeSQL, we can use the psql command to connect to Redshift.
Command syntax is as follows.
#psql -h <host> -U <user> -d <database> -p <port>
<host> is the Redshift cluster endpoint. <user> is the user name for Redshift cluster. <database> is the database name. <port> is the Redshift cluster port.
This command will will prompt for the password.