Adrien NAYRAT wrote:
> On 08/08/2018 04:09 PM, czezz 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?
> >
> > Cheers,
> > czezz
>
> Hello,
>
> Maybe this article by Daniel
On 08/08/2018 04:09 PM, czezz 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?
Cheers,
czezz
Hello,
Maybe this article by Daniel could help you :
On Wed, 8 Aug 2018 at 10:14, David G. Johnston
wrote:
>
> On Wednesday, August 8, 2018, czezz 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
Hi, thanks that is actually a good hint :)
Dnia 8 sierpnia 2018 16:13 David G. Johnston
david.g.johns...@gmail.com napisał(a):
On Wednesday, August 8, 2018, czezzcz...@o2.pl
wrote: Hi everyone, I want to aks if anyone knows is there a way to
If the num of tables is smallish you could run smth like
select * from (
select table1::text as thecol from table1
UNION select table2::text FROM table2
UNION select table3::text FROM table3
UNION .
) as qry WHERE thecol ~* 'some pattern';
On 08/08/2018 17:09, czezz wrote:
Hi everyone,
I
On Wednesday, August 8, 2018, czezz 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
