PostgreSQL, Get comma separated list of tables based on a table name.

query.sql

-- select table by name 
SELECT string_agg(table_name, ', ')
  FROM information_schema.tables
 WHERE table_schema='public'
   AND table_type='BASE TABLE'
   AND table_name like 't_%'
   
-- select only empty tables
select
	string_agg(relname, ', ')
from pg_catalog.pg_statio_user_tables
where relname like 't_%' and pg_size_pretty(pg_relation_size(relid)) = '0 bytes'