Postgres Pro
Downloads
Home   >   mailing lists

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

From czezz
Subject Odp: Re: Postgres - search for value throughout many tables?
Date
Msg-id ceacaafe38944ecd8a5d552da50189a7@grupawp.pl
Whole thread Raw
In response to Re: Postgres - search for value throughout many tables?  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
Hi, thanks that is actually a good hint :)

Dnia 8 sierpnia 2018 16:13 David G. Johnston <david.g.johnston@gmail.com> napisał(a):

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: Achilleas Mantzios
Date:
Subject: Re: Postgres - search for value throughout many tables?
Next
From: Vijay Rajah
Date:
Subject: Postgres replication -- .done file in slave