create user testuser password 'mm2022';
create database testdb owner testuser;
create schema testschema owner testuser;
另一个schema可以访问这个schema
grant usage on schema testschema to test1schema;
grant all on database testdb to testuser;
用户下有数据库,数据库下有模式<schema>
连接到某个数据库
\c testdb
查看该数据库下的schema的owner
\dn
修改schema的owner
alter schema testschema owner to testuser
列出所有数据库
\l