redshift_show_create_table

python script, 'show create table' equivalent for aws redshift. Command-line syntax is similar to pg_dump.

Another option for getting this information is the v_generate_tbl_ddl.sql admin view from AWS Labs: https://github.com/awslabs/amazon-redshift-utils/blob/master/src/AdminViews/

Command-line parameters

Basic usage:

./show_create_table.py -h HOST -U USER -d DBNAME [-W PASSWORD] [-p PORT]
[-f FILE] [-F {directory}] [-n SCHEMANAME]
[-t TABLENAME]

Required parameters

• [-h/--host=] HOSTNAME: hostname for Redshift database
• [-U/--user=] USERNAME: username to connect to Redshift database with
• [-d/--dbname=] DBNAME: name of database to connect to on host

Optional parameters

• [-W/--password=] PASSWORD: Redshift password for username. If not provided, it will look for .pgpass credential file under user home directory, or file defined in PGPASSFILE system variable. See https://www.postgresql.org/docs/9.1/static/libpq-pgpass.html
• [-p/--port=] PORT: port to connect to, defaults to 5432
• [-f/--file=] FILE: file/directory to write output to, defaults to standard output
• [-F/--format=] FORMAT: requires --file, currently only valid option (and default) is 'directory', which creates directories for each non-system schema and creates a separate SQL file for each table/view
• [-n/--schema=] SCHEMANAME: name of schema to show tables from, if none provided it will iterate over all non-system schemas
• [-t/--table=] TABLENAME: name of a single table to dump, if none provided it will iterate over all in schema