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 |
网友评论