Redshift - Listing tables, views, columns from database information schema

redshift_show_schema.sql

SELECT
    t.table_schema
  , t.table_name
  , c.column_name
  , c.data_type
  , CASE
        WHEN c.character_maximum_length IS NOT NULL THEN c.character_maximum_length
        ELSE c.numeric_precision
        END AS max_length
  , is_nullable
FROM information_schema.tables t
         JOIN information_schema.columns c ON t.table_schema = c.table_schema AND t.table_name = c.table_name
WHERE t.table_schema NOT IN ('information_schema', 'pg_catalog')
ORDER BY 1, 2, 3
;