改变postgreSQL的默认schema

来源:互联网 发布:掌握系统优化的方法 编辑:程序博客网 时间:2024/05/15 23:46
-- Use this to show the current search_path-- Should return: "$user",publicSHOW search_path;-- Create another schemaCREATE SCHEMA my_schema;GRANT ALL ON SCHEMA my_schema TO my_user;-- To change search_path on a connection-levelSET search_path TO my_schema;-- To change search_path on a database-levelALTER database "my_database" SET search_path TO my_schema;
0 1
原创粉丝点击