select_table_and_columns_from_postgres.sql

select_table_and_columns_from_postgres.sql

select 
  tables.table_name, 
  columns.column_name

from information_schema.tables
inner join information_schema.columns 
on information_schema.columns.table_name = information_schema.tables.table_name

where tables.table_schema = 'public'
and tables.table_type = 'BASE TABLE'

order by tables.table_name, columns.column_name;