Is there a way to do a SQL dump from Amazon Redshift?
Could you use the SQL workbench/J client?
We are currently using Workbench/J successfuly with Redshift.
Regarding dumps, at the time there is no schema export tool available in Redshift (pg_dump doesn't work), although data can always be extracted via queries.
Hope to help.
EDIT: Remember that things like sort and distribution keys are not reflected on the code generated by Workbench/J. Take a look to the system table
pg_table_def to see info on every field. It states if a field is sortkey or distkey, and such info. Documentation on that table: