bruno-uy · May 27, 2022 12:29
diff --git a/add_schema_to_search_path.sql b/add_schema_to_search_path.sql
 -- Problem: you don't see all the schemas when querying PG_TABLE_DEF
 -- Solution:
 -- 1. First check if the schema you're trying to query is on the search path
 show search_path;
 -- 2. Add the missing one(s) to the search path (imagine the result was only public and you're missing data_warehouse and matching)
 set search_path to '$user', public, data_warehouse, matching;  -- No matter which is your user, use '$user'
	-- Problem: you don't see all the schemas when querying PG_TABLE_DEF
	-- Solution:
	-- 1. First check if the schema you're trying to query is on the search path
	show search_path;
	-- 2. Add the missing one(s) to the search path (imagine the result was only public and you're missing data_warehouse and matching)
	set search_path to '$user', public, data_warehouse, matching; -- No matter which is your user, use '$user'