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

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.