Page Comparison

select 'truncate table SCHEMA.' || tablename || ';' generated_statements
from pg_catalog.pg_tables 
where schemaname = 'SCHEMA' 
and tablename not like 'dl_%'
and tablename not like 'ext_%'
and tablename like '%ENTITYNAME'
order by substr(tablename,3), tablename;