List All Schemas Tables and Columns in RedShift
September 27, 2020
List all Schemas/Tables/Columns in RedShift & Postgres

This script returns all schemas, tables and columns within RedShift or Postgres. select table_schema, table_name, ordinal_position as position, column_name, data_type, case when character_maximum_length is not null then character_maximum_length else numeric_precision end as max_length, is_nullable, column_default as default_value from information_schema.columns order by table_schema, table_name, ordinal_position;