在磐维数据库中如何切换到其他数据库中呢?可以使用如下命令:
postgres=# select datname from pg_database;
datname
-----------
template1
postgres
template0
panweidb
(4 rows)
postgres=# \c panweidb
Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "panweidb" as user "omm".
在磐维数据库中如何切换到其他用户呢?可以使用如下命令:
panweidb=# select usename from pg_user;
usename
----------
omm
pwadmin
pwsso
pwaudit
sdr_repl
dtp
(6 rows)
panweidb=# \c - dtp
Password for user dtp:
Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "panweidb" as user "dtp".
panweidb=>