Iam using pg_dump command for dumping the ddl. but it's not giving me the distkey and sortkey is there other way to get a full length ddl with create statment (with distkey & sortkey), alter statment, comment on columns and table and grant statement. Please help me ouy
1 Answers
Yes. AWSLAbs on github (https://github.com/awslabs/amazon-redshift-utils) has many utilities for managing Redshift. One of which is a view that can be used to gather the full DDL of Redshift tables - v_generate_tbl_ddl. See: https://github.com/awslabs/amazon-redshift-utils/blob/master/src/AdminViews/v_generate_tbl_ddl.sql
Related