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.
