II. 客戶端應(yīng)用程序
這部分包含PostgreSQL客戶端應(yīng)用程序和工具的參考信息。這里的命令并非全部是通用工具,有些可能需要特殊的權(quán)限。這些應(yīng)用的一般性特點(diǎn)是它們可以在任何主機(jī)上運(yùn)行,與數(shù)據(jù)庫服務(wù)器所處的位置無關(guān)。
- Table of Contents
-
clusterdb?--?cluster a PostgreSQL database
-
createdb?--?create a new PostgreSQL database
-
createlang?--?define a new PostgreSQL procedural language
-
createuser?--?define a new PostgreSQL user account
-
dropdb?--?remove a PostgreSQL database
-
droplang?--?remove a PostgreSQL procedural language
-
dropuser?--?remove a PostgreSQL user account
-
ecpg?--?embedded SQL C preprocessor
- pg_config?--?retrieve information about the installed version of PostgreSQL
- pg_dump?--? extract a PostgreSQL database into a script file or other archive file
-
pg_dumpall?--?extract a PostgreSQL database cluster into a script file
- pg_restore?--? restore a PostgreSQL database from an
archive file created by pg_dump
-
psql?--? PostgreSQL interactive terminal
-
reindexdb?--?reindex a PostgreSQL database
-
vacuumdb?--?garbage-collect and analyze a PostgreSQL database