Re: Postgres - search for value throughout many tables?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: czezz <czezz(at)o2(dot)pl>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Postgres - search for value throughout many tables?
Date: 2018-08-08 14:13:41
Message-ID: CAKFQuwZvE54zXk8+t+sZtKDROS-5nzgN+=wiWoV9k0ng49jkuA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday, August 8, 2018, czezz <czezz(at)o2(dot)pl> wrote:

> Hi everyone,
> I want to aks if anyone knows is there a way to search for specific
> "value" throughout list of tables OR all tables in databse?
>

Can you pg_dump your database to plain text and search that? Nothing built
in provides that ability though you possibly could work up something using
dynamic sql.

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Achilleas Mantzios 2018-08-08 14:33:30 Re: Postgres - search for value throughout many tables?
Previous Message czezz 2018-08-08 14:09:07 Postgres - search for value throughout many tables?