PostgreSQL - find all tables with specific column names

 SELECT DISTINCT TABLE_NAME 

FROM INFORMATION_SCHEMA.COLUMNS

WHERE COLUMN_NAME IN ('name','surname')

AND TABLE_SCHEMA='dirask';