VI. 參考手冊(cè)
這份參考里的條目給各個(gè)相關(guān)對(duì)象提供了權(quán)威、完整、正式的概要。有關(guān)使用PostgreSQL的更多信息(敘述、教程、例子),可以在PostgreSQL文檔集的其它部分找到。參閱在每個(gè)參考頁(yè)里的交叉引用。
參考手冊(cè)里的條目也可以在傳統(tǒng)的"man"頁(yè)里獲得。
- Table of Contents
- I. SQL命令
- ABORT?--?abort the current transaction
- ALTER AGGREGATE?--?change the definition of an aggregate function
- ALTER CONVERSION?--?change the definition of a conversion
- ALTER DATABASE?--?change a database
- ALTER DEFAULT PRIVILEGES?--?define default access privileges
- ALTER DOMAIN?--? change the definition of a domain
- ALTER FOREIGN DATA WRAPPER?--?change the definition of a foreign-data wrapper
- ALTER FUNCTION?--?change the definition of a function
- ALTER GROUP?--?change role name or membership
- ALTER INDEX?--?change the definition of an index
- ALTER LANGUAGE?--?change the definition of a procedural language
- ALTER LARGE OBJECT?--?change the definition of a large object
- ALTER OPERATOR?--?change the definition of an operator
- ALTER OPERATOR CLASS?--?change the definition of an operator class
- ALTER OPERATOR FAMILY?--?change the definition of an operator family
- ALTER ROLE?--?change a database role
- ALTER SCHEMA?--?change the definition of a schema
- ALTER SEQUENCE?--? change the definition of a sequence generator
- ALTER SERVER?--?change the definition of a foreign server
- ALTER TABLE?--?change the definition of a table
- ALTER TABLESPACE?--?change the definition of a tablespace
- ALTER TEXT SEARCH CONFIGURATION?--?change the definition of a text search configuration
- ALTER TEXT SEARCH DICTIONARY?--?change the definition of a text search dictionary
- ALTER TEXT SEARCH PARSER?--?change the definition of a text search parser
- ALTER TEXT SEARCH TEMPLATE?--?change the definition of a text search template
- ALTER TRIGGER?--?change the definition of a trigger
- ALTER TYPE?--? change the definition of a type
- ALTER USER?--?change a database role
- ALTER USER MAPPING?--?change the definition of a user mapping
- ALTER VIEW?--?change the definition of a view
- ANALYZE?--?collect statistics about a database
- BEGIN?--?start a transaction block
- CHECKPOINT?--?force a transaction log checkpoint
- CLOSE?--?close a cursor
- CLUSTER?--?cluster a table according to an index
- COMMENT?--?define or change the comment of an object
- COMMIT?--?commit the current transaction
- COMMIT PREPARED?--?commit a transaction that was earlier prepared for two-phase commit
- COPY?--?copy data between a file and a table
- CREATE AGGREGATE?--?define a new aggregate function
- CREATE CAST?--?define a new cast
- CREATE CONSTRAINT TRIGGER?--?define a new constraint trigger
- CREATE CONVERSION?--?define a new encoding conversion
- CREATE DATABASE?--?create a new database
- CREATE DOMAIN?--?define a new domain
- CREATE FOREIGN DATA WRAPPER?--?define a new foreign-data wrapper
- CREATE FUNCTION?--?define a new function
- CREATE GROUP?--?define a new database role
- CREATE INDEX?--?define a new index
- CREATE LANGUAGE?--?define a new procedural language
- CREATE OPERATOR?--?define a new operator
- CREATE OPERATOR CLASS?--?define a new operator class
- CREATE OPERATOR FAMILY?--?define a new operator family
- CREATE ROLE?--?define a new database role
- CREATE RULE?--?define a new rewrite rule
- CREATE SCHEMA?--?define a new schema
- CREATE SEQUENCE?--?define a new sequence generator
- CREATE SERVER?--?define a new foreign server
- CREATE TABLE?--?define a new table
- CREATE TABLE AS?--?define a new table from the results of a query
- CREATE TABLESPACE?--?define a new tablespace
- CREATE TEXT SEARCH CONFIGURATION?--?define a new text search configuration
- CREATE TEXT SEARCH DICTIONARY?--?define a new text search dictionary
- CREATE TEXT SEARCH PARSER?--?define a new text search parser
- CREATE TEXT SEARCH TEMPLATE?--?define a new text search template
- CREATE TRIGGER?--?define a new trigger
- CREATE TYPE?--?define a new data type
- CREATE USER?--?define a new database role
- CREATE USER MAPPING?--?define a new mapping of a user to a foreign server
- CREATE VIEW?--?define a new view
- DEALLOCATE?--?deallocate a prepared statement
- DECLARE?--?define a cursor
- DELETE?--?delete rows of a table
- DISCARD?--?discard session state
- DO?--?execute an anonymous code block
- DROP AGGREGATE?--?remove an aggregate function
- DROP CAST?--?remove a cast
- DROP CONVERSION?--?remove a conversion
- DROP DATABASE?--?remove a database
- DROP DOMAIN?--?remove a domain
- DROP FOREIGN DATA WRAPPER?--?remove a foreign-data wrapper
- DROP FUNCTION?--?remove a function
- DROP GROUP?--?remove a database role
- DROP INDEX?--?remove an index
- DROP LANGUAGE?--?remove a procedural language
- DROP OPERATOR?--?remove an operator
- DROP OPERATOR CLASS?--?remove an operator class
- DROP OPERATOR FAMILY?--?remove an operator family
- DROP OWNED?--?remove database objects owned by a database role
- DROP ROLE?--?remove a database role
- DROP RULE?--?remove a rewrite rule
- DROP SCHEMA?--?remove a schema
- DROP SEQUENCE?--?remove a sequence
- DROP SERVER?--?remove a foreign server descriptor
- DROP TABLE?--?remove a table
- DROP TABLESPACE?--?remove a tablespace
- DROP TEXT SEARCH CONFIGURATION?--?remove a text search configuration
- DROP TEXT SEARCH DICTIONARY?--?remove a text search dictionary
- DROP TEXT SEARCH PARSER?--?remove a text search parser
- DROP TEXT SEARCH TEMPLATE?--?remove a text search template
- DROP TRIGGER?--?remove a trigger
- DROP TYPE?--?remove a data type
- DROP USER?--?remove a database role
- DROP USER MAPPING?--?remove a user mapping for a foreign server
- DROP VIEW?--?remove a view
- END?--?commit the current transaction
- EXECUTE?--?execute a prepared statement
- EXPLAIN?--?show the execution plan of a statement
- FETCH?--?retrieve rows from a query using a cursor
- GRANT?--?define access privileges
- INSERT?--?create new rows in a table
- LISTEN?--?listen for a notification
- LOAD?--?load a shared library file
- LOCK?--?lock a table
- MOVE?--?position a cursor
- NOTIFY?--?generate a notification
- PREPARE?--?prepare a statement for execution
- PREPARE TRANSACTION?--?prepare the current transaction for two-phase commit
- REASSIGN OWNED?--?change the ownership of database objects owned by a database role
- REINDEX?--?rebuild indexes
- RELEASE SAVEPOINT?--?destroy a previously defined savepoint
- RESET?--?restore the value of a run-time parameter to the default value
- REVOKE?--?remove access privileges
- ROLLBACK?--?abort the current transaction
- ROLLBACK PREPARED?--?cancel a transaction that was earlier prepared for two-phase commit
- ROLLBACK TO SAVEPOINT?--?roll back to a savepoint
- SAVEPOINT?--?define a new savepoint within the current transaction
- SELECT?--?retrieve rows from a table or view
- SELECT INTO?--?define a new table from the results of a query
- SET?--?change a run-time parameter
- SET CONSTRAINTS?--?set constraint check timing for the current transaction
- SET ROLE?--?set the current user identifier of the current session
- SET SESSION AUTHORIZATION?--?set the session user identifier and the current user identifier of the current session
- SET TRANSACTION?--?set the characteristics of the current transaction
- SHOW?--?show the value of a run-time parameter
- START TRANSACTION?--?start a transaction block
- TRUNCATE?--?empty a table or set of tables
- UNLISTEN?--?stop listening for a notification
- UPDATE?--?update rows of a table
- VACUUM?--?garbage-collect and optionally analyze a database
- VALUES?--?compute a set of rows
- II. 客戶端應(yīng)用程序
-
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
- III. PostgreSQL服務(wù)器應(yīng)用程序
- initdb?--?create a new PostgreSQL database cluster
-
pg_controldata?--?display control information of a PostgreSQL database cluster
-
pg_ctl?--?initialize, start, stop, or restart a PostgreSQL server
-
pg_resetxlog?--?reset the write-ahead log and other control information of a PostgreSQL database cluster
-
postgres?--?PostgreSQL database server
-
postmaster?--?PostgreSQL database server