SHOW search_path; -- Create another schema CREATE SCHEMA my_schema; GRANT ALL ON SCHEMA my_schema TO my_user; -- To change search_path on a connection-level SET search_path TO my_schema; -- To change search_path on a database-level ALTER database "my_database" SET search_path TO my_schema;
postgreSQL的默认schema
最新推荐文章于 2024-06-11 15:30:11 发布