psql是PostgreSQL命令行交互接口
先所以下postgres用户,在postgres编译安装完成后,会自动创建一个名为postgres的用户
首先切换到postgres用户:
普通用户(可能)无法直接通过
su postgres
命令切换到postgres用户
需要先切换到root用户
在切换到postgres用户
su root
su postgres
接下来进入psql命令:
$ psql
psql (9.5.4)
Type "help" for help.
postgres=#
输入help
postgres=# help
You are using psql, the command-line interface to PostgreSQL.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
postgres=#
我们可以看到psql的介绍:
You are using psql, the command-line interface to PostgreSQL.
\l 命令可以列出所有的数据库
\l[+] [PATTERN] list databases
例如,我现在的数据库
postgres=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
--------------+--------------+----------+-------------+-------------+-----------------------
catmaid | catmaid_user | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
test_catmaid | catmaid_user | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
(5 rows)
postgres=#
\du 列出所有的用户
\du[+] [PATTERN] list roles
例如,我现在的所有用户
postgres=# \du
List of roles
Role name | Attributes | Member of
--------------+------------------------------------------------------------+-----------
catmaid_user | Superuser, Create DB | {}
postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
postgres=#