PostgreSQL或者GP数据库创建schema及添加search_path

话不多说直接Show My Code

/**在 TEST_DM库中新建 schema：test_dm 并授权*/
CREATE schema test_dm authorization uown_test_dm;
COMMENT ON schema "test_dm" IS 'DM层测试应用';
--授权
GRANT ALL ON SCHEMA test_dm TO uapp_test_dm;
GRANT USAGE ON SCHEMA test_dm TO public;

/** 添加 search_path */ 
-- 查新当前用户 search_path
show search_path;

-- 修改当前用户 search_path
 set search_path = "$user", public, test_dm;

-- 修改指定数据库 search_path
alter database "test_DM" set search_path to public, test_dm