在postgresql中查找具有特定名称的任何列中出现的所有字符串

I have a Postgresql database with many tables, some of these tables have a column called 'description'. Some of these descriptions contain the word 'dog'. How can I print the tables names for the tables that have the string 'dog' anywhere in the column 'description', case insensitive?I have a Postgresql database with many tables,