Answered Question

boomerx01

January 05, 2009 07:21 PM

Is there a way to search an entire database?

I am running PostGres SQL 8.2, using SQLManager Lite to view the DB.

Is there a function or query to write that will search the entire database for a text string (inside a column)? There are about 50 tables and going through them manually would be a nightmare.

Interesting Question? Yes (0) No (0)

RSS

Best Answer Chosen by Asker

darth cont...

January 05, 2009 08:01 PM

If you have Excel handy, you could copy and paste a bunch of select statements together for each of the tables.

For example, say in row 1, you have column A have the Table name, and column B the field name.

Column C you could have a formula something like:

="SELECT " && B1 && " FROM " && A1 "

Then copy this formula so that it appears down the line in column C for the rest of the entries.

Copy those into a PostGres command session (I don't think you could do this via SQLManager, you might need to do this manually).

Failing that, hopefully someone will answer with fresher knowledge of PostGres, or maybe someone who could suggest building some PHP or Perl script which could do something similar.

Helpful Answer?

(2)

(0) Tip darth continent for this answer

Permalink | Report

Answer this Question

Ask a Question

Top of Page

Buy Mahalo Dollars with Credit Card or PayPal

Top Members

This Week All Time

buddawiggi
2nd Degree Black Belt
27933 Points
M$806.66 Earned
opher
Purple Belt
4757 Points
M$203.72 Earned
annelisle
Purple Belt
3308 Points
M$99.72 Earned

See All

Most Popular Tags

mahalo(1641)

twitter(956)

iphone(468)

music(465)

google(361)

food(327)

internet(310)

online(298)

beer(281)

money(267)

movies(265)

apple(253)

facebook(244)

aotd(235)

answers(231)

health(221)

video(210)

free(207)

dog(205)

windows(198)

See All

Welcome New Members

anpro21, December 01, 2009 05:57 PM
primodebt, December 01, 2009 05:52 PM
spypress, December 01, 2009 05:50 PM
toothjoe, December 01, 2009 05:36 PM
moniquemontano, December 01, 2009 05:35 PM

Mahalo Dollars are the currency of Mahalo Answers.

Each Mahalo Dollar costs $1.

Once you earn more than 40 Mahalo Dollars, you can request to be paid via PayPal. Each Mahalo Dollar is currently worth $0.75 when paid out via PayPal. Learn More