In phpmyadmin, I can easily search for text in the tables in my databases using the search tab. Was wondering if I can do the same with the postgres installed locally on my computer. I have looked at the menus there but I can't find anything like that. Does anyone know how I can search a whole db for a text that I enter?
You could probably create a procedure to this, but out of the top of my head I'd just do a database dump (pg_dump) and search the file.