SELECT * FROM where table like 'i'?

Question

PostgreSQL

Guys, help with SQL query:
you need to select everything from the table LIKE '%%'
found the table like this:

SELECT * FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_NAME LIKE '%i%'

I try again like this, but still only the name of the table gives

WITH NewScores AS (
    SELECT table_name FROM INFORMATION_SCHEMA.TABLES
    WHERE TABLE_NAME LIKE 'irina'
)
SELECT * from NewScores;

Answer 1

Compose a query manually, automatically go through all the fields with one LIKE% i% operator and also select a table - it will not work.