On Thu, Aug 30, 2018 at 1:44 PM, Ruiqiang Chen <chenrq2005(at)gmail(dot)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.