pgsql 9.6版本，搜索全库，某个字段的数据包含了这个值 LIUWEI

数据库执行脚本

DO $$

DECLARE

table_record record;

BEGIN

FOR table_record IN (

SELECT

table_name, column_name

FROM

information_schema.columns

WHERE

data_type IN ('text', 'varchar', 'character varying') -- 可根据实际情况调整数据类型范围

AND table_schema = 'public' -- 或者指定你需要查询的模式名称

) LOOP

EXECUTE format('

SELECT * FROM %I

WHERE %I LIKE ''%%LIUWEI%%'';',

table_record.table_name,

table_record.column_name

);

END LOOP;

END $$ LANGUAGE plpgsql;