FG
💻 Software

Searching a whole postgres db for a string

Fresh5 days ago
Mar 15, 202617517 views
Confidence Score0%
0%

Problem

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

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Searching a whole postgres db for a string

Low Risk

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.

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment