Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres - search for value throughout many tables? - Mailing list pgsql-general

From David G. Johnston
Subject Re: Postgres - search for value throughout many tables?
Date
Msg-id CAKFQuwZvE54zXk8+t+sZtKDROS-5nzgN+=wiWoV9k0ng49jkuA@mail.gmail.com
Whole thread Raw
In response to Postgres - search for value throughout many tables?  (czezz <czezz@o2.pl>)
Responses Re: Postgres - search for value throughout many tables?
List pgsql-general
Tree view
On Wednesday, August 8, 2018, czezz <czezz@o2.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.

pgsql-general by date:

Previous
From: czezz
Date:
Subject: Postgres - search for value throughout many tables?
Next
From: Achilleas Mantzios
Date:
Subject: Re: Postgres - search for value throughout many tables?