SQL Query - List PostgreSQL tables per schema

postgresql_tables.sql

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
where table_schema in ('public')
order by table_schema, 
         table_name,
         ordinal_position;