系列2 基础命令
2023-03-06 本文已影响0人
午觉不眠Orz
1. 二进制客户端命令
更多详情资料，查询官网：https://www.postgresql.org/docs/current/reference-client.html
| 命令 | 说明 | 示例用法(注:edens是hostname) |
|---|---|---|
| clusterdb | 集群PostgreSQL数据库 | clusterdb 【dbname】 |
| createdb | 创建一个新的PostgreSQL数据库 | createdb -p 5000 -h eden -T template0 -e demo |
| createuser | 定义一个新的PostgreSQL用户帐户 | createuser --interactive joe; createuser -P -s -e joe; |
| dropdb | 删除一个PostgreSQL数据库 | dropdb -p 5000 -h eden -i -e demo |
| dropuser | 删除一个PostgreSQL用户帐户 | dropuser -p 5000 -h eden -i -e joe |
| ecpg | 嵌入式 SQL C 预处理器 | ecpg prog1.pgc(甚少使用) |
| pg_amcheck | 检查一个或多个PostgreSQL数据库，与PostgreSQL 14.0 及更高版本一起使用 | 略 |
| pg_basebackup | 对PostgreSQL集群进行基础备份 | 略，更多详情见官网pg_basebackup |
| pgbench | 在PostgreSQL上运行基准测试 | 略，更多详情见官网pgbench |
| pg_config | 检索有关已安装的PostgreSQL版本的信息，尤其参数信息 | 略 |
| pg_dump | 将PostgreSQL数据库提取到脚本文件或其他存档文件中 | pg_dump mydb > db.sql |
| pg_dumpall | 将PostgreSQL数据库集群提取到脚本文件中 | pg_dumpall > db.out |
| pg_isready | 检查PostgreSQL服务器的连接状态 | pg_isready -h localhost -p 5433 |
| pg_receivewal | 从PostgreSQL服务器流式传输预写日志 | 略 |
| pg_recvlogical | 控制PostgreSQL逻辑解码流 | 略 |
| pg_restore | 从pg_dump创建的存档文件恢复PostgreSQL数据库 | 略，更多详情见官网pg_restore |
| pg_verifybackup | 验证PostgreSQL集群基础备份的完整性 | 略 |
| psql | PostgreSQL交互式终端 | 略 |
| reindexdb | 重新索引PostgreSQL数据库 | reindexdb test |
| vacuumdb | 垃圾收集和分析PostgreSQL数据库 | vacuumdb test |
2. psql连接数据库，基础命令
记住?查询即可
常见的有
| 命令 | 解释 |
|---|---|
| \d[S+] | list tables, views, and sequences |
| \d[S+] NAME | describe table, view, sequence, or index |
| \da[S] [PATTERN] | list aggregates |
| \dA[+] [PATTERN] | list access methods |
| \db[+] [PATTERN] | list tablespaces |
| \dc[S+] [PATTERN] | list conversions |
| \dC[+] [PATTERN] | list casts |
| \dd[S] [PATTERN] | show object descriptions not displayed elsewhere |
| \dD[S+] [PATTERN] | list domains |
| \ddp [PATTERN] | list default privileges |
| \dE[S+] [PATTERN] | list foreign tables |
| \det[+] [PATTERN] | list foreign tables |
| \des[+] [PATTERN] | list foreign servers |
| \deu[+] [PATTERN] | list user mappings |
| \dew[+] [PATTERN] | list foreign-data wrappers |
| \df[anptw][S+] [PATRN] | list [only agg/normal/procedures/trigger/window] functions |
| \dF[+] [PATTERN] | list text search configurations |
| \dFd[+] [PATTERN] | list text search dictionaries |
| \dFp[+] [PATTERN] | list text search parsers |
| \dFt[+] [PATTERN] | list text search templates |
| \dg[S+] [PATTERN] | list roles |
| \di[S+] [PATTERN] | list indexes |
| \dl | list large objects, same as \lo_list |
| \dL[S+] [PATTERN] | list procedural languages |
| \dm[S+] [PATTERN] | list materialized views |
| \dn[S+] [PATTERN] | list schemas |
| \do[S+] [PATTERN] | list operators |
| \dO[S+] [PATTERN] | list collations |
| \dp [PATTERN] | list table, view, and sequence access privileges |
| \drds [PATRN1 [PATRN2]] | list per-database role settings |
| \dRp[+] [PATTERN] | list replication publications |
| \dRs[+] [PATTERN] | list replication subscriptions |
| \ds[S+] [PATTERN] | list sequences |
| \dt[S+] [PATTERN] | list tables |
| \dT[S+] [PATTERN] | list data types |
| \du[S+] [PATTERN] | list roles |
| \dv[S+] [PATTERN] | list views |
| \dx[+] [PATTERN] | list extensions |
| \dy[+] [PATTERN] | list event triggers |
| \l[+] [PATTERN] | list databases |
| \sf[+] FUNCNAME | show a function's definition |
| \sv[+] VIEWNAME | show a view's definition |
| \z [PATTERN] | same as \dp |
