Thanks! On Thu, Aug 30, 2018 at 4:51 PM David G. Johnston < david.g.johns...@gmail.com> wrote:
> On Thu, Aug 30, 2018 at 1:44 PM, Ruiqiang Chen <chenrq2...@gmail.com> > wrote: > >> Does anyone have experience of searching a value in a variable/field in >> all tables in a schema? >> > > SELECT 'Tbl1'::text AS loc, fld > FROM schema.tbl1 > WHERE fld = 'value' > [UNION ALL > SELECT 'Tbl2'::text AS loc, fld > FROM schema.tbl2 > WHERE fld = 'value' > ...] > > David J. > >
