Redshift

We use SQLWorkbench to connect to the Redshift database with the following command:

$ /path/to/SQLWorkbench/sqlwbconsole.sh -url="jdbc:postgresql://path.to.redshift/database" -username="user" \
  -password="password" -driver="org.postgresql.Driver" -driverJar="/path/to/postgresql-8.4-703.jdbc4.jar" \
  -autocommit="ON" -vardef=#AWS_ACCESS_KEY_ID=access_key_id,AWS_SECRET_ACCESS_KEY=secret_access_key;