SELECT table_schema, table_name
FROM information_schema.tables
WHERE table_name ILIKE '%invest_strateg%'
AND table_name NOT ILIKE '%history%'
AND table_name NOT ILIKE '%sharer%'
ORDER BY table_schema
SELECT table_schema, table_name
FROM information_schema.tables
WHERE table_schema NOT IN ('information_schema', 'pg_catalog')
AND table_name ILIKE '%strateg%'
ORDER BY table_schema, table_name