Postgresql find value in all tables
PostgreSQL Query: Finding a Value in All Tables In PostgreSQL, you can search for a specific value across all tables in a database using the following query: SELECT table_schema, table_name, column_name FROM information_schema.columns WHERE table_schema NOT IN (‘information_schema’, ‘pg_catalog’) — Exclude system catalog tables AND data_type IN (‘character’, ‘character varying’, ‘text’) — Search only text-like … Read more