PostgreSQL - find all tables with specific column names Get link Facebook X Pinterest Email Other Apps January 03, 2023 SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME IN ('name','surname') AND TABLE_SCHEMA='dirask'; Read more