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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: searching a value in a variable/field in all tables in a schema
Дата
Msg-id CAKFQuwaONZObovF2COnS_d1yH_pD4rhwOmyHL+O=fPJFHGwxZw@mail.gmail.com
обсуждение исходный текст
Ответ на searching a value in a variable/field in all tables in a schema  (Ruiqiang Chen <chenrq2005@gmail.com>)
Ответы Re: searching a value in a variable/field in all tables in a schema
Список pgsql-general
Дерево обсуждения
On Thu, Aug 30, 2018 at 1:44 PM, Ruiqiang Chen <chenrq2005@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.

В списке pgsql-general по дате отправления: