有没有办法从Amazon Redshift执行SQL转储 [英] Is there a way to do a SQL dump from Amazon Redshift

问题描述

是否可以从Amazon Redshift执行SQL转储?

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

您可以使用SQL Workbench/J客户端吗?

Could you use the SQL workbench/J client?

推荐答案

我们当前正在Redshift上成功使用Workbench/J.

We are currently using Workbench/J successfuly with Redshift.

关于转储，尽管始终可以通过查询来提取数据，但在Redshift中没有可用的模式导出工具(pg_dump不起作用).

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.

希望能提供帮助.

编辑:请记住，排序和分发键之类的内容不会反映在Workbench/J生成的代码中.查看系统表pg_table_def，以查看每个字段上的信息.它说明字段是sortkey还是distkey，以及此类信息.该表上的文档:

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

这篇关于有没有办法从Amazon Redshift执行SQL转储的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！