Re: searching a value in a variable/field in all tables in a schema

[Ruiqiang Chen <chenrq2005@xxxxxxxxx>]

Thanks! 

On Thu, Aug 30, 2018 at 4:51 PM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Thu, Aug 30, 2018 at 1:44 PM, Ruiqiang Chen <chenrq2005@xxxxxxxxx> 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.