Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 1

up vote 5 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
    
Nice. I was going to suggest finding all textual columns with the System Catalogs but I like your answer better (for smallish databases) –  Jared Beck May 28 '13 at 22:03
    
And for massive databases? –  coderama Jun 14 '13 at 13:09
    
If it's a one time thing searching a dump from a backup is probably still the easiest thing. If you need it more ofter, use something like Sphinx or elasticsearch. –  Elmar Weber Jun 18 '13 at 13:07
    
it's a 'silly' answer but the one that actually works :) So, is there someone who could post a proper SQL-Query? –  three Nov 26 '13 at 7:16

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.