Elm Elm - 2 years ago 361
SQL Question

Is there a way to do a SQL dump from Amazon Redshift

Is there a way to do a SQL dump from Amazon Redshift?

Could you use the SQL workbench/J client?

Answer Source

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:


Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download