search for a string or a number in an entire database

With just sql queries, this would need some amount of scripting as mentioned on stackoverflow. But with visual database tools like DBeaver, it's just a simple operation of doing a full-text search, with the option of including numeric fields or not - "Search in numbers" and the option to search Large Objects or not - "Search in LOBs".