postgresql连接到schema

连接到postgresql	psql --username=platrw --port=5432  --host=10.19.141.87 -d postgres
用户名	库名
创建用户：	CREATE USER bi WITH PASSWORD '123456qwer'
djp01	djp01
创建schema	CREATE SCHEMA dim;
重命名schema	alter schema djp02 rename to djp03;
禁用public	revoke create on schema public from public;

更改默认的schema

show search_path

create schema my_schema

grant all on schema my_schema to my_user;

set search_path to my_schema;</