Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 0 down vote favorite

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?

share|improve this question
1  
You're comparing 2 different things: phpMyAdmin is not a DB, it's a PHP application written to administrate MySQL DBs, while PostgreSQL is a DB, like MySQL. – m0skit0 Feb 17 '12 at 9:52
When you download postgress and install, pgadmin is also installed – yankitwizzy Feb 17 '12 at 13:01

1 Answer

up vote 3 down vote accepted

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.