469 shaares
SELECT t.table_schema,
t.table_name
FROM information_schema.tables t
INNER JOIN information_schema.columns c
ON c.table_name = t.table_name
AND c.table_schema = t.table_schema
WHERE c.column_name = 'user_ipad_id'
AND t.table_schema NOT IN ( 'information_schema', 'pg_catalog' )
AND t.table_type = 'BASE TABLE'
ORDER BY t.table_schema;