Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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
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


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.