If the num of tables is smallish you could run smth like
select * from ( select table1::text as thecol from table1 UNION select table2::text FROM table2 UNION select table3::text FROM table3 UNION ..... ) as qry WHERE thecol ~* 'some pattern'; On 08/08/2018 17:09, czezz wrote:
Hi everyone, I want to aks if anyone knows is there a way to search for specific "value" throughout list of tables OR all tables in databse? Cheers, czezz
-- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt
