select_table_columns.sql

select t.table_schema, t.table_name,
  'TRUNCATE public.' || t.table_name || ' CASCADE;', 'insert into public.'
  || t.table_name || '(' || string_agg(c.column_name, ',') || ') select ' || string_agg(c.column_name, ',') || ' from '
  || 'main.' || substring(t.table_name from 6) || ';'
from information_schema.columns c
  join information_schema.tables t on t.table_name = c.table_name and t.table_schema = 'public'
where t.table_schema in ('public') and t.table_type = 'BASE TABLE'
GROUP BY t.table_schema, t.table_name;