连接到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; |
show search_path
create schema my_schema
grant all on schema my_schema to my_user;
set search_path to my_schema;</