highgo=# \db --列举出所有的表空间
List of tablespaces
Name | Owner | Location
------------+--------+----------
pg_default | highgo |
pg_global | highgo |
(2 rows)
highgo=# \dn ----列举出所有的schema
List of schemas
Name | Owner
----------------+--------
hgdb_catalog | highgo
oracle_catalog | highgo
public | highgo
(3 rows)
highgo=# \du 列举出所有的角色或用户
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------+-----------
highgo | Superuser, Create role, Create DB, Replication | {}
highgo=# create role aaaa;
CREATE ROLE
List of tablespaces
Name | Owner | Location
------------+--------+----------
pg_default | highgo |
pg_global | highgo |
(2 rows)
highgo=# \dn ----列举出所有的schema
List of schemas
Name | Owner
----------------+--------
hgdb_catalog | highgo
oracle_catalog | highgo
public | highgo
(3 rows)
highgo=# \du 列举出所有的角色或用户
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------+-----------
highgo | Superuser, Create role, Create DB, Replication | {}
highgo=# create role aaaa;
CREATE ROLE