Odp: Re: Postgres - search for value throughout many tables?

From: czezz <czezz(at)o2(dot)pl>
To: David G(dot) Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Odp: Re: Postgres - search for value throughout many tables?
Date: 2018-08-08 15:05:45
Message-ID: ceacaafe38944ecd8a5d552da50189a7@grupawp.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, thanks that is actually a good hint :)




Dnia 8 sierpnia 2018 16:13 David G. Johnston &lt;david(dot)g(dot)johnston(at)gmail(dot)com&gt; napisał(a):


On Wednesday, August 8, 2018, czezz &lt; czezz(at)o2(dot)pl &gt; wrote: Hi everyone, I want to aks if anyone knows is there a way to search for specific &#34;value&#34; 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

Browse pgsql-general by date

  From Date Subject
Next Message Vijay Rajah 2018-08-08 15:21:23 Postgres replication -- .done file in slave
Previous Message Achilleas Mantzios 2018-08-08 14:33:30 Re: Postgres - search for value throughout many tables?