历史版本。 PostgreSQL 9.2 已结束支持。 2017-11-09. 请参阅 当前版本手册.
PostgreSQL Client Applications
This part contains reference information for PostgreSQL client applications and utilities. Not all of these commands are of general utility; some might require special privileges. The common feature of these applications is that they can be run on any host, independent of where the database server resides.
When specified on the command line, user and database names have their case preserved — the presence of spaces or special characters might require quoting. Table names and other identifiers do not have their case preserved, except where documented, and might require quoting.
目录
- clusterdb — 聚簇一个PostgreSQL数据库
- createdb — 创建新的PostgreSQL数据库
- createlang — 安装一个 PostgreSQL 过程语言
- createuser — 定义一个新的PostgreSQL用户账户
- dropdb — 移除一个PostgreSQL数据库
- droplang — 移除一个 PostgreSQL 过程语言
- dropuser — 移除一个PostgreSQL用户账户
- ecpg — 嵌入式 SQL C 预处理器
- pg_basebackup — 获取PostgreSQL集簇的基础备份
- pg_config — 获取已安装的PostgreSQL版本的信息
- pg_dump — extract a PostgreSQL database into a script file or other archive file
- pg_dumpall — 将一个PostgreSQL数据库集簇转储为脚本文件
- pg_receivexlog — streams transaction logs from a PostgreSQL cluster
- pg_restore — restore a PostgreSQL database from an archive file created by pg_dump
- psql — PostgreSQL interactive terminal
- reindexdb — 重建一个PostgreSQL数据库中的索引
- vacuumdb — 清理并分析一个 PostgreSQL 数据库