Page Comparison

select 'truncate table EXTMY_INT_RDMSCHEMA.' || table_name || ';' as generated_statements
from all_tables 
where
  owner = 'EXTMY_INT_RDMSCHEMA'              /* set this to your data location schema */
  and table_name not like 'DL_%'   /* do not truncate these system tables   */
  and table_name not like 'EXT_%'  /* do not truncate these system tables   */
  and table_name like '%STORE'     /* edit these filters as needed          */
order by substr(table_name,3), table_name;

select 'truncate table SCHEMAmy_schema.' || tablename || ';' as generated_statements
from pg_catalog.pg_tables 
where schemaname = 'SCHEMAmy_schema'     /* set this to your data location schema */
  and tablename not like 'dl_%'    /* do not truncate these system tables   */
  and tablename not like 'ext_%'   /* do not truncate these system tables   */
  and tablename like '%ENTITYNAME' /* edit these filters as needed          */
order by substr(tablename,3), tablename;