Elm Elm - 7 months ago 135
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

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:

http://docs.aws.amazon.com/redshift/latest/dg/r_PG_TABLE_DEF.html

Comments