I answered the previous comment thinking of RDS... You can certainly add a note anywhere appropriate about RDS.
As for the original question of Redshift some have used the pg translator with the red shift driver, but there's been no full testing so another translator could be needed at some point.
Should Amazon RDS be mentioned here and indicate that the appropriate translator should be used based on the underlying provisioned RDBMS being used?