In my database are many text columns where values are empty strings (`''`). The empty strings need to be set to `NULL`. I do not know the exact schemas, tables and columns in this database or rather I want to write a general solution which can be reused.

How would I write a query / function to find all text columns in all tables in all schemas and update all columns with empty strings (`''`) to `NULL`?