跳转到主要内容

书籍

PostgreSQL 文档

PostgreSQL 文档。内容保持上游原样。

1 章230 页更新于 4 小时前

开始阅读

目录230

  1. 第 1 章 Doc 230 页
    1. 1.1 Backup and Restore backup As with everything that contains valuable data, PostgreSQL databases should be backed up regularly. ... 4 小时前
    2. 1.2 Client Authentication client authentication When a client application connects to the database server, it specifies which Postgre... 4 小时前
    3. 1.3 Data Manipulation The previous chapter discussed how to create tables and other structures to hold your data. Now it is time ... 4 小时前
    4. 1.4 A Brief History of PostgreSQL history of PostgreSQL The object-relational database management system now known as PostgreSQL is derived f... 4 小时前
    5. 1.5 Indexes index Indexes are a common way to enhance database performance. An index allows the database server to find... 4 小时前
    6. 1.6 legal 2026 1996–2026 The PostgreSQL Global Development Group PostgreSQL Database Management System (also known as... 4 小时前
    7. 1.7 Routine Database Maintenance Tasks maintenance routine maintenance PostgreSQL, like any database software, requires that certain tasks be perf... 4 小时前
    8. 1.8 Managing Databases database Every instance of a running PostgreSQL server manages one or more databases. Databases are therefo... 4 小时前
    9. 1.9 Concurrency Control concurrency This chapter describes the behavior of the PostgreSQL database system when two or more sessions... 4 小时前
    10. 1.10 Conventions The following conventions are used in the synopsis of a command: brackets ( [ and ]) indicate optional par... 4 小时前
    11. 1.11 Queries query SELECT The previous chapters explained how to create tables, how to fill them with data, and how to m... 4 小时前
    12. 1.12 abort ABORT ABORT 7 SQL - Language Statements ABORT abort the current transaction ABORT [ WORK | TRANSACTION ] [ ... 4 小时前
    13. 1.13 alter_aggregate ALTER AGGREGATE ALTER AGGREGATE 7 SQL - Language Statements ALTER AGGREGATE change the definition of an agg... 4 小时前
    14. 1.14 alter_collation ALTER COLLATION ALTER COLLATION 7 SQL - Language Statements ALTER COLLATION change the definition of a coll... 4 小时前
    15. 1.15 alter_conversion ALTER CONVERSION ALTER CONVERSION 7 SQL - Language Statements ALTER CONVERSION change the definition of a c... 4 小时前
    16. 1.16 alter_database ALTER DATABASE ALTER DATABASE 7 SQL - Language Statements ALTER DATABASE change a database ALTER DATABASE n... 4 小时前
    17. 1.17 alter_default_privileges ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES 7 SQL - Language Statements ALTER DEFAULT PRIVILEGES defi... 4 小时前
    18. 1.18 alter_domain ALTER DOMAIN ALTER DOMAIN 7 SQL - Language Statements ALTER DOMAIN change the definition of a domain ALTER ... 4 小时前
    19. 1.19 alter_event_trigger ALTER EVENT TRIGGER ALTER EVENT TRIGGER 7 SQL - Language Statements ALTER EVENT TRIGGER change the definiti... 4 小时前
    20. 1.20 alter_extension ALTER EXTENSION ALTER EXTENSION 7 SQL - Language Statements ALTER EXTENSION change the definition of an ext... 4 小时前
    21. 1.21 alter_foreign_data_wrapper ALTER FOREIGN DATA WRAPPER ALTER FOREIGN DATA WRAPPER 7 SQL - Language Statements ALTER FOREIGN DATA WRAPPE... 4 小时前
    22. 1.22 alter_foreign_table ALTER FOREIGN TABLE ALTER FOREIGN TABLE 7 SQL - Language Statements ALTER FOREIGN TABLE change the definiti... 4 小时前
    23. 1.23 alter_function ALTER FUNCTION ALTER FUNCTION 7 SQL - Language Statements ALTER FUNCTION change the definition of a functio... 4 小时前
    24. 1.24 alter_group ALTER GROUP ALTER GROUP 7 SQL - Language Statements ALTER GROUP change role name or membership ALTER GROUP ... 4 小时前
    25. 1.25 alter_index ALTER INDEX ALTER INDEX 7 SQL - Language Statements ALTER INDEX change the definition of an index ALTER IND... 4 小时前
    26. 1.26 alter_language ALTER LANGUAGE ALTER LANGUAGE 7 SQL - Language Statements ALTER LANGUAGE change the definition of a procedu... 4 小时前
    27. 1.27 alter_large_object ALTER LARGE OBJECT ALTER LARGE OBJECT 7 SQL - Language Statements ALTER LARGE OBJECT change the definition ... 4 小时前
    28. 1.28 alter_materialized_view ALTER MATERIALIZED VIEW ALTER MATERIALIZED VIEW 7 SQL - Language Statements ALTER MATERIALIZED VIEW change ... 4 小时前
    29. 1.29 alter_opclass ALTER OPERATOR CLASS ALTER OPERATOR CLASS 7 SQL - Language Statements ALTER OPERATOR CLASS change the defin... 4 小时前
    30. 1.30 alter_operator ALTER OPERATOR ALTER OPERATOR 7 SQL - Language Statements ALTER OPERATOR change the definition of an operat... 4 小时前
    31. 1.31 alter_opfamily ALTER OPERATOR FAMILY ALTER OPERATOR FAMILY 7 SQL - Language Statements ALTER OPERATOR FAMILY change the de... 4 小时前
    32. 1.32 alter_policy ALTER POLICY ALTER POLICY 7 SQL - Language Statements ALTER POLICY change the definition of a row-level sec... 4 小时前
    33. 1.33 alter_procedure ALTER PROCEDURE ALTER PROCEDURE 7 SQL - Language Statements ALTER PROCEDURE change the definition of a proc... 4 小时前
    34. 1.34 alter_publication ALTER PUBLICATION ALTER PUBLICATION 7 SQL - Language Statements ALTER PUBLICATION change the definition of ... 4 小时前
    35. 1.35 alter_role ALTER ROLE ALTER ROLE 7 SQL - Language Statements ALTER ROLE change a database role ALTER ROLE role_specifi... 4 小时前
    36. 1.36 alter_routine ALTER ROUTINE ALTER ROUTINE 7 SQL - Language Statements ALTER ROUTINE change the definition of a routine AL... 4 小时前
    37. 1.37 alter_rule ALTER RULE ALTER RULE 7 SQL - Language Statements ALTER RULE change the definition of a rule ALTER RULE nam... 4 小时前
    38. 1.38 alter_schema ALTER SCHEMA ALTER SCHEMA 7 SQL - Language Statements ALTER SCHEMA change the definition of a schema ALTER ... 4 小时前
    39. 1.39 alter_sequence ALTER SEQUENCE ALTER SEQUENCE 7 SQL - Language Statements ALTER SEQUENCE change the definition of a sequenc... 4 小时前
    40. 1.40 alter_server ALTER SERVER ALTER SERVER 7 SQL - Language Statements ALTER SERVER change the definition of a foreign serve... 4 小时前
    41. 1.41 alter_statistics ALTER STATISTICS ALTER STATISTICS 7 SQL - Language Statements ALTER STATISTICS change the definition of an ... 4 小时前
    42. 1.42 alter_subscription ALTER SUBSCRIPTION ALTER SUBSCRIPTION 7 SQL - Language Statements ALTER SUBSCRIPTION change the definition ... 4 小时前
    43. 1.43 alter_system ALTER SYSTEM ALTER SYSTEM 7 SQL - Language Statements ALTER SYSTEM change a server configuration parameter ... 4 小时前
    44. 1.44 alter_table ALTER TABLE ALTER TABLE 7 SQL - Language Statements ALTER TABLE change the definition of a table ALTER TABL... 4 小时前
    45. 1.45 alter_tablespace ALTER TABLESPACE ALTER TABLESPACE 7 SQL - Language Statements ALTER TABLESPACE change the definition of a t... 4 小时前
    46. 1.46 alter_trigger ALTER TRIGGER ALTER TRIGGER 7 SQL - Language Statements ALTER TRIGGER change the definition of a trigger AL... 4 小时前
    47. 1.47 alter_tsconfig ALTER TEXT SEARCH CONFIGURATION ALTER TEXT SEARCH CONFIGURATION 7 SQL - Language Statements ALTER TEXT SEAR... 4 小时前
    48. 1.48 alter_tsdictionary ALTER TEXT SEARCH DICTIONARY ALTER TEXT SEARCH DICTIONARY 7 SQL - Language Statements ALTER TEXT SEARCH DIC... 4 小时前
    49. 1.49 alter_tsparser ALTER TEXT SEARCH PARSER ALTER TEXT SEARCH PARSER 7 SQL - Language Statements ALTER TEXT SEARCH PARSER chan... 4 小时前
    50. 1.50 alter_tstemplate ALTER TEXT SEARCH TEMPLATE ALTER TEXT SEARCH TEMPLATE 7 SQL - Language Statements ALTER TEXT SEARCH TEMPLAT... 4 小时前
    51. 1.51 alter_type ALTER TYPE ALTER TYPE 7 SQL - Language Statements ALTER TYPE change the definition of a type ALTER TYPE nam... 4 小时前
    52. 1.52 alter_user ALTER USER ALTER USER 7 SQL - Language Statements ALTER USER change a database role ALTER USER role_specifi... 4 小时前
    53. 1.53 alter_user_mapping ALTER USER MAPPING ALTER USER MAPPING 7 SQL - Language Statements ALTER USER MAPPING change the definition ... 4 小时前
    54. 1.54 alter_view ALTER VIEW ALTER VIEW 7 SQL - Language Statements ALTER VIEW change the definition of a view ALTER VIEW [ I... 4 小时前
    55. 1.55 analyze ANALYZE ANALYZE 7 SQL - Language Statements ANALYZE collect statistics about a database ANALYZE [ ( option ... 4 小时前
    56. 1.56 begin BEGIN BEGIN 7 SQL - Language Statements BEGIN start a transaction block BEGIN [ WORK | TRANSACTION ] [ tran... 4 小时前
    57. 1.57 call CALL CALL 7 SQL - Language Statements CALL invoke a procedure CALL name ( [ argument ] [, ...] ) Descriptio... 4 小时前
    58. 1.58 checkpoint CHECKPOINT CHECKPOINT 7 SQL - Language Statements CHECKPOINT force a write-ahead log checkpoint CHECKPOINT ... 4 小时前
    59. 1.59 close CLOSE cursor CLOSE CLOSE 7 SQL - Language Statements CLOSE close a cursor CLOSE { name | ALL } Description ... 4 小时前
    60. 1.60 cluster CLUSTER CLUSTER 7 SQL - Language Statements CLUSTER cluster a table according to an index CLUSTER [ ( optio... 4 小时前
    61. 1.61 clusterdb clusterdb clusterdb 1 Application clusterdb cluster a PostgreSQL database clusterdb connection-option optio... 4 小时前
    62. 1.62 comment COMMENT COMMENT 7 SQL - Language Statements COMMENT define or change the comment of an object COMMENT ON { ... 4 小时前
    63. 1.63 commit COMMIT COMMIT 7 SQL - Language Statements COMMIT commit the current transaction COMMIT [ WORK | TRANSACTION... 4 小时前
    64. 1.64 commit_prepared COMMIT PREPARED COMMIT PREPARED 7 SQL - Language Statements COMMIT PREPARED commit a transaction that was e... 4 小时前
    65. 1.65 copy COPY COPY 7 SQL - Language Statements COPY copy data between a file and a table COPY table_name [ ( column_... 4 小时前
    66. 1.66 create_access_method CREATE ACCESS METHOD CREATE ACCESS METHOD 7 SQL - Language Statements CREATE ACCESS METHOD define a new acc... 4 小时前
    67. 1.67 create_aggregate CREATE AGGREGATE CREATE AGGREGATE 7 SQL - Language Statements CREATE AGGREGATE define a new aggregate funct... 4 小时前
    68. 1.68 create_cast CREATE CAST CREATE CAST 7 SQL - Language Statements CREATE CAST define a new cast CREATE CAST ( source_type... 4 小时前
    69. 1.69 create_collation CREATE COLLATION CREATE COLLATION 7 SQL - Language Statements CREATE COLLATION define a new collation CREAT... 4 小时前
    70. 1.70 create_conversion CREATE CONVERSION CREATE CONVERSION 7 SQL - Language Statements CREATE CONVERSION define a new encoding con... 4 小时前
    71. 1.71 create_database CREATE DATABASE CREATE DATABASE 7 SQL - Language Statements CREATE DATABASE create a new database CREATE DA... 4 小时前
    72. 1.72 create_domain CREATE DOMAIN CREATE DOMAIN 7 SQL - Language Statements CREATE DOMAIN define a new domain CREATE DOMAIN nam... 4 小时前
    73. 1.73 create_event_trigger CREATE EVENT TRIGGER CREATE EVENT TRIGGER 7 SQL - Language Statements CREATE EVENT TRIGGER define a new eve... 4 小时前
    74. 1.74 create_extension CREATE EXTENSION CREATE EXTENSION 7 SQL - Language Statements CREATE EXTENSION install an extension CREATE ... 4 小时前
    75. 1.75 create_foreign_data_wrapper CREATE FOREIGN DATA WRAPPER CREATE FOREIGN DATA WRAPPER 7 SQL - Language Statements CREATE FOREIGN DATA WRA... 4 小时前
    76. 1.76 create_foreign_table CREATE FOREIGN TABLE CREATE FOREIGN TABLE 7 SQL - Language Statements CREATE FOREIGN TABLE define a new for... 4 小时前
    77. 1.77 create_function CREATE FUNCTION CREATE FUNCTION 7 SQL - Language Statements CREATE FUNCTION define a new function CREATE [ ... 4 小时前
    78. 1.78 create_group CREATE GROUP CREATE GROUP 7 SQL - Language Statements CREATE GROUP define a new database role CREATE GROUP ... 4 小时前
    79. 1.79 create_index CREATE INDEX CREATE INDEX 7 SQL - Language Statements CREATE INDEX define a new index CREATE [ UNIQUE ] IND... 4 小时前
    80. 1.80 create_language CREATE LANGUAGE CREATE LANGUAGE 7 SQL - Language Statements CREATE LANGUAGE define a new procedural languag... 4 小时前
    81. 1.81 create_materialized_view CREATE MATERIALIZED VIEW CREATE MATERIALIZED VIEW 7 SQL - Language Statements CREATE MATERIALIZED VIEW defi... 4 小时前
    82. 1.82 create_opclass CREATE OPERATOR CLASS CREATE OPERATOR CLASS 7 SQL - Language Statements CREATE OPERATOR CLASS define a new ... 4 小时前
    83. 1.83 create_operator CREATE OPERATOR CREATE OPERATOR 7 SQL - Language Statements CREATE OPERATOR define a new operator CREATE OP... 4 小时前
    84. 1.84 create_opfamily CREATE OPERATOR FAMILY CREATE OPERATOR FAMILY 7 SQL - Language Statements CREATE OPERATOR FAMILY define a n... 4 小时前
    85. 1.85 create_policy CREATE POLICY CREATE POLICY 7 SQL - Language Statements CREATE POLICY define a new row-level security polic... 4 小时前
    86. 1.86 create_procedure CREATE PROCEDURE CREATE PROCEDURE 7 SQL - Language Statements CREATE PROCEDURE define a new procedure CREAT... 4 小时前
    87. 1.87 create_publication CREATE PUBLICATION CREATE PUBLICATION 7 SQL - Language Statements CREATE PUBLICATION define a new publicati... 4 小时前
    88. 1.88 create_role CREATE ROLE CREATE ROLE 7 SQL - Language Statements CREATE ROLE define a new database role CREATE ROLE name... 4 小时前
    89. 1.89 create_rule CREATE RULE CREATE RULE 7 SQL - Language Statements CREATE RULE define a new rewrite rule CREATE [ OR REPLA... 4 小时前
    90. 1.90 create_schema CREATE SCHEMA CREATE SCHEMA 7 SQL - Language Statements CREATE SCHEMA define a new schema CREATE SCHEMA sch... 4 小时前
    91. 1.91 create_sequence CREATE SEQUENCE CREATE SEQUENCE 7 SQL - Language Statements CREATE SEQUENCE define a new sequence generator... 4 小时前
    92. 1.92 create_server CREATE SERVER CREATE SERVER 7 SQL - Language Statements CREATE SERVER define a new foreign server CREATE SE... 4 小时前
    93. 1.93 create_statistics CREATE STATISTICS CREATE STATISTICS 7 SQL - Language Statements CREATE STATISTICS define extended statistic... 4 小时前
    94. 1.94 create_subscription CREATE SUBSCRIPTION CREATE SUBSCRIPTION 7 SQL - Language Statements CREATE SUBSCRIPTION define a new subscr... 4 小时前
    95. 1.95 create_table CREATE TABLE CREATE TABLE 7 SQL - Language Statements CREATE TABLE define a new table CREATE [ persistence_... 4 小时前
    96. 1.96 create_table_as CREATE TABLE AS CREATE TABLE AS 7 SQL - Language Statements CREATE TABLE AS define a new table from the res... 4 小时前
    97. 1.97 create_tablespace CREATE TABLESPACE CREATE TABLESPACE 7 SQL - Language Statements CREATE TABLESPACE define a new tablespace C... 4 小时前
    98. 1.98 create_transform CREATE TRANSFORM CREATE TRANSFORM 7 SQL - Language Statements CREATE TRANSFORM define a new transform CREAT... 4 小时前
    99. 1.99 create_trigger CREATE TRIGGER transition tables ephemeral named relation CREATE TRIGGER 7 SQL - Language Statements CREATE... 4 小时前
    100. 1.100 create_tsconfig CREATE TEXT SEARCH CONFIGURATION CREATE TEXT SEARCH CONFIGURATION 7 SQL - Language Statements CREATE TEXT S... 4 小时前
    101. 1.101 create_tsdictionary CREATE TEXT SEARCH DICTIONARY CREATE TEXT SEARCH DICTIONARY 7 SQL - Language Statements CREATE TEXT SEARCH ... 4 小时前
    102. 1.102 create_tsparser CREATE TEXT SEARCH PARSER CREATE TEXT SEARCH PARSER 7 SQL - Language Statements CREATE TEXT SEARCH PARSER d... 4 小时前
    103. 1.103 create_tstemplate CREATE TEXT SEARCH TEMPLATE CREATE TEXT SEARCH TEMPLATE 7 SQL - Language Statements CREATE TEXT SEARCH TEMP... 4 小时前
    104. 1.104 create_type CREATE TYPE CREATE TYPE 7 SQL - Language Statements CREATE TYPE define a new data type CREATE TYPE name AS ... 4 小时前
    105. 1.105 create_user CREATE USER CREATE USER 7 SQL - Language Statements CREATE USER define a new database role CREATE USER name... 4 小时前
    106. 1.106 create_user_mapping CREATE USER MAPPING CREATE USER MAPPING 7 SQL - Language Statements CREATE USER MAPPING define a new mappin... 4 小时前
    107. 1.107 create_view CREATE VIEW CREATE VIEW 7 SQL - Language Statements CREATE VIEW define a new view CREATE [ OR REPLACE ] [ T... 4 小时前
    108. 1.108 createdb createdb createdb 1 Application createdb create a new PostgreSQL database createdb connection-option option... 4 小时前
    109. 1.109 createuser createuser createuser 1 Application createuser define a new PostgreSQL user account createuser connection-o... 4 小时前
    110. 1.110 deallocate DEALLOCATE prepared statements removing DEALLOCATE 7 SQL - Language Statements DEALLOCATE deallocate a prep... 4 小时前
    111. 1.111 declare DECLARE cursor DECLARE portal DECLARE DECLARE 7 SQL - Language Statements DECLARE define a cursor DECLARE n... 4 小时前
    112. 1.112 delete DELETE DELETE 7 SQL - Language Statements DELETE delete rows of a table [ WITH [ RECURSIVE ] with_query [, ... 4 小时前
    113. 1.113 discard DISCARD DISCARD 7 SQL - Language Statements DISCARD discard session state DISCARD { ALL | PLANS | SEQUENCES... 4 小时前
    114. 1.114 do DO anonymous code blocks DO 7 SQL - Language Statements DO execute an anonymous code block DO [ LANGUAGE la... 4 小时前
    115. 1.115 drop_access_method DROP ACCESS METHOD DROP ACCESS METHOD 7 SQL - Language Statements DROP ACCESS METHOD remove an access metho... 4 小时前
    116. 1.116 drop_aggregate DROP AGGREGATE DROP AGGREGATE 7 SQL - Language Statements DROP AGGREGATE remove an aggregate function DROP ... 4 小时前
    117. 1.117 drop_cast DROP CAST DROP CAST 7 SQL - Language Statements DROP CAST remove a cast DROP CAST [ IF EXISTS ] ( source_ty... 4 小时前
    118. 1.118 drop_collation DROP COLLATION DROP COLLATION 7 SQL - Language Statements DROP COLLATION remove a collation DROP COLLATION ... 4 小时前
    119. 1.119 drop_conversion DROP CONVERSION DROP CONVERSION 7 SQL - Language Statements DROP CONVERSION remove a conversion DROP CONVER... 4 小时前
    120. 1.120 drop_database DROP DATABASE DROP DATABASE 7 SQL - Language Statements DROP DATABASE remove a database DROP DATABASE [ IF ... 4 小时前
    121. 1.121 drop_domain DROP DOMAIN DROP DOMAIN 7 SQL - Language Statements DROP DOMAIN remove a domain DROP DOMAIN [ IF EXISTS ] n... 4 小时前
    122. 1.122 drop_event_trigger DROP EVENT TRIGGER DROP EVENT TRIGGER 7 SQL - Language Statements DROP EVENT TRIGGER remove an event trigge... 4 小时前
    123. 1.123 drop_extension DROP EXTENSION DROP EXTENSION 7 SQL - Language Statements DROP EXTENSION remove an extension DROP EXTENSION... 4 小时前
    124. 1.124 drop_foreign_data_wrapper DROP FOREIGN DATA WRAPPER DROP FOREIGN DATA WRAPPER 7 SQL - Language Statements DROP FOREIGN DATA WRAPPER r... 4 小时前
    125. 1.125 drop_foreign_table DROP FOREIGN TABLE DROP FOREIGN TABLE 7 SQL - Language Statements DROP FOREIGN TABLE remove a foreign table... 4 小时前
    126. 1.126 drop_function DROP FUNCTION DROP FUNCTION 7 SQL - Language Statements DROP FUNCTION remove a function DROP FUNCTION [ IF ... 4 小时前
    127. 1.127 drop_group DROP GROUP DROP GROUP 7 SQL - Language Statements DROP GROUP remove a database role DROP GROUP [ IF EXISTS ... 4 小时前
    128. 1.128 drop_index DROP INDEX DROP INDEX 7 SQL - Language Statements DROP INDEX remove an index DROP INDEX [ CONCURRENTLY ] [ ... 4 小时前
    129. 1.129 drop_language DROP LANGUAGE DROP LANGUAGE 7 SQL - Language Statements DROP LANGUAGE remove a procedural language DROP [ P... 4 小时前
    130. 1.130 drop_materialized_view DROP MATERIALIZED VIEW DROP MATERIALIZED VIEW 7 SQL - Language Statements DROP MATERIALIZED VIEW remove a m... 4 小时前
    131. 1.131 drop_opclass DROP OPERATOR CLASS DROP OPERATOR CLASS 7 SQL - Language Statements DROP OPERATOR CLASS remove an operator ... 4 小时前
    132. 1.132 drop_operator DROP OPERATOR DROP OPERATOR 7 SQL - Language Statements DROP OPERATOR remove an operator DROP OPERATOR [ IF... 4 小时前
    133. 1.133 drop_opfamily DROP OPERATOR FAMILY DROP OPERATOR FAMILY 7 SQL - Language Statements DROP OPERATOR FAMILY remove an operat... 4 小时前
    134. 1.134 drop_owned DROP OWNED DROP OWNED 7 SQL - Language Statements DROP OWNED remove database objects owned by a database ro... 4 小时前
    135. 1.135 drop_policy DROP POLICY DROP POLICY 7 SQL - Language Statements DROP POLICY remove a row-level security policy from a t... 4 小时前
    136. 1.136 drop_procedure DROP PROCEDURE DROP PROCEDURE 7 SQL - Language Statements DROP PROCEDURE remove a procedure DROP PROCEDURE ... 4 小时前
    137. 1.137 drop_publication DROP PUBLICATION DROP PUBLICATION 7 SQL - Language Statements DROP PUBLICATION remove a publication DROP PU... 4 小时前
    138. 1.138 drop_role DROP ROLE DROP ROLE 7 SQL - Language Statements DROP ROLE remove a database role DROP ROLE [ IF EXISTS ] na... 4 小时前
    139. 1.139 drop_routine DROP ROUTINE DROP ROUTINE 7 SQL - Language Statements DROP ROUTINE remove a routine DROP ROUTINE [ IF EXIST... 4 小时前
    140. 1.140 drop_rule DROP RULE DROP RULE 7 SQL - Language Statements DROP RULE remove a rewrite rule DROP RULE [ IF EXISTS ] nam... 4 小时前
    141. 1.141 drop_schema DROP SCHEMA DROP SCHEMA 7 SQL - Language Statements DROP SCHEMA remove a schema DROP SCHEMA [ IF EXISTS ] n... 4 小时前
    142. 1.142 drop_sequence DROP SEQUENCE DROP SEQUENCE 7 SQL - Language Statements DROP SEQUENCE remove a sequence DROP SEQUENCE [ IF ... 4 小时前
    143. 1.143 drop_server DROP SERVER DROP SERVER 7 SQL - Language Statements DROP SERVER remove a foreign server descriptor DROP SER... 4 小时前
    144. 1.144 drop_statistics DROP STATISTICS DROP STATISTICS 7 SQL - Language Statements DROP STATISTICS remove extended statistics DROP... 4 小时前
    145. 1.145 drop_subscription DROP SUBSCRIPTION DROP SUBSCRIPTION 7 SQL - Language Statements DROP SUBSCRIPTION remove a subscription DRO... 4 小时前
    146. 1.146 drop_table DROP TABLE DROP TABLE 7 SQL - Language Statements DROP TABLE remove a table DROP TABLE [ IF EXISTS ] name [... 4 小时前
    147. 1.147 drop_tablespace DROP TABLESPACE DROP TABLESPACE 7 SQL - Language Statements DROP TABLESPACE remove a tablespace DROP TABLES... 4 小时前
    148. 1.148 drop_transform DROP TRANSFORM DROP TRANSFORM 7 SQL - Language Statements DROP TRANSFORM remove a transform DROP TRANSFORM ... 4 小时前
    149. 1.149 drop_trigger DROP TRIGGER DROP TRIGGER 7 SQL - Language Statements DROP TRIGGER remove a trigger DROP TRIGGER [ IF EXIST... 4 小时前
    150. 1.150 drop_tsconfig DROP TEXT SEARCH CONFIGURATION DROP TEXT SEARCH CONFIGURATION 7 SQL - Language Statements DROP TEXT SEARCH ... 4 小时前
    151. 1.151 drop_tsdictionary DROP TEXT SEARCH DICTIONARY DROP TEXT SEARCH DICTIONARY 7 SQL - Language Statements DROP TEXT SEARCH DICTIO... 4 小时前
    152. 1.152 drop_tsparser DROP TEXT SEARCH PARSER DROP TEXT SEARCH PARSER 7 SQL - Language Statements DROP TEXT SEARCH PARSER remove ... 4 小时前
    153. 1.153 drop_tstemplate DROP TEXT SEARCH TEMPLATE DROP TEXT SEARCH TEMPLATE 7 SQL - Language Statements DROP TEXT SEARCH TEMPLATE r... 4 小时前
    154. 1.154 drop_type DROP TYPE DROP TYPE 7 SQL - Language Statements DROP TYPE remove a data type DROP TYPE [ IF EXISTS ] name [... 4 小时前
    155. 1.155 drop_user DROP USER DROP USER 7 SQL - Language Statements DROP USER remove a database role DROP USER [ IF EXISTS ] na... 4 小时前
    156. 1.156 drop_user_mapping DROP USER MAPPING DROP USER MAPPING 7 SQL - Language Statements DROP USER MAPPING remove a user mapping for... 4 小时前
    157. 1.157 drop_view DROP VIEW DROP VIEW 7 SQL - Language Statements DROP VIEW remove a view DROP VIEW [ IF EXISTS ] name [, ...... 4 小时前
    158. 1.158 dropdb dropdb dropdb 1 Application dropdb remove a PostgreSQL database dropdb connection-option option dbname Desc... 4 小时前
    159. 1.159 dropuser dropuser dropuser 1 Application dropuser remove a PostgreSQL user account dropuser connection-option option... 4 小时前
    160. 1.160 ecpg-ref ecpg ecpg 1 Application ecpg embedded SQL C preprocessor ecpg option file Description ecpg is the embedded ... 4 小时前
    161. 1.161 end END END 7 SQL - Language Statements END commit the current transaction END [ WORK | TRANSACTION ] [ AND [ N... 4 小时前
    162. 1.162 execute EXECUTE prepared statements executing EXECUTE 7 SQL - Language Statements EXECUTE execute a prepared statem... 4 小时前
    163. 1.163 fetch FETCH cursor FETCH FETCH 7 SQL - Language Statements FETCH retrieve rows from a query using a cursor FETCH ... 4 小时前
    164. 1.164 grant GRANT GRANT 7 SQL - Language Statements GRANT define access privileges GRANT { { SELECT | INSERT | UPDATE |... 4 小时前
    165. 1.165 import_foreign_schema IMPORT FOREIGN SCHEMA IMPORT FOREIGN SCHEMA 7 SQL - Language Statements IMPORT FOREIGN SCHEMA import table ... 4 小时前
    166. 1.166 initdb initdb initdb 1 Application initdb create a new PostgreSQL database cluster initdb option --pgdata -D datad... 4 小时前
    167. 1.167 insert INSERT INSERT 7 SQL - Language Statements INSERT create new rows in a table [ WITH [ RECURSIVE ] with_query... 4 小时前
    168. 1.168 listen LISTEN LISTEN 7 SQL - Language Statements LISTEN listen for a notification LISTEN channel Description LISTE... 4 小时前
    169. 1.169 load LOAD LOAD 7 SQL - Language Statements LOAD load a shared library file LOAD ' filename ' Description This co... 4 小时前
    170. 1.170 lock LOCK LOCK 7 SQL - Language Statements LOCK lock a table LOCK [ TABLE ] [ ONLY ] name [ * ] [, ...] [ IN loc... 4 小时前
    171. 1.171 merge MERGE MERGE 7 SQL - Language Statements MERGE conditionally insert, update, or delete rows of a table [ WIT... 4 小时前
    172. 1.172 move MOVE cursor MOVE MOVE 7 SQL - Language Statements MOVE position a cursor MOVE [ direction ] [ FROM | IN ] c... 4 小时前
    173. 1.173 notify NOTIFY NOTIFY 7 SQL - Language Statements NOTIFY generate a notification NOTIFY channel [ , payload ] Descr... 4 小时前
    174. 1.174 pg_amcheck pg_amcheck pg_amcheck 1 Application pg_amcheck checks for corruption in one or more PostgreSQL databases pg... 4 小时前
    175. 1.175 pg_basebackup pg_basebackup pg_basebackup 1 Application pg_basebackup take a base backup of a PostgreSQL cluster pg_baseb... 4 小时前
    176. 1.176 pg_checksums pg_checksums pg_checksums 1 Application pg_checksums enable, disable or check data checksums in a PostgreSQ... 4 小时前
    177. 1.177 pg_combinebackup pg_combinebackup pg_combinebackup 1 Application pg_combinebackup reconstruct a full backup from an incremen... 4 小时前
    178. 1.178 pg_config-ref pg_config pg_config 1 Application pg_config retrieve information about the installed version of PostgreSQL ... 4 小时前
    179. 1.179 pg_controldata pg_controldata pg_controldata 1 Application pg_controldata display control information of a PostgreSQL data... 4 小时前
    180. 1.180 pg_createsubscriber pg_createsubscriber pg_createsubscriber 1 Application pg_createsubscriber convert a physical replica into a... 4 小时前
    181. 1.181 pg_ctl-ref pg_ctl pg_ctl 1 Application pg_ctl initialize, start, stop, or control a PostgreSQL server pg_ctl init[db] ... 4 小时前
    182. 1.182 pg_dump pg_dump pg_dump 1 Application pg_dump export a PostgreSQL database as an SQL script or to other formats pg_... 4 小时前
    183. 1.183 pg_dumpall pg_dumpall pg_dumpall 1 Application pg_dumpall extract a PostgreSQL database cluster into a script file pg_... 4 小时前
    184. 1.184 pg_isready pg_isready pg_isready 1 Application pg_isready check the connection status of a PostgreSQL server pg_isread... 4 小时前
    185. 1.185 pg_receivewal pg_receivewal pg_receivewal 1 Application pg_receivewal stream write-ahead logs from a PostgreSQL server pg... 4 小时前
    186. 1.186 pg_recvlogical pg_recvlogical pg_recvlogical 1 Application pg_recvlogical control PostgreSQL logical decoding streams pg_r... 4 小时前
    187. 1.187 pg_resetwal pg_resetwal pg_resetwal 1 Application pg_resetwal reset the write-ahead log and other control information o... 4 小时前
    188. 1.188 pg_restore pg_restore pg_restore 1 Application pg_restore restore a PostgreSQL database from an archive file created b... 4 小时前
    189. 1.189 pg_rewind pg_rewind pg_rewind 1 Application pg_rewind synchronize a PostgreSQL data directory with another data direc... 4 小时前
    190. 1.190 pg_verifybackup pg_verifybackup pg_verifybackup 1 Application pg_verifybackup verify the integrity of a base backup of a Po... 4 小时前
    191. 1.191 pg_waldump pg_waldump pg_waldump 1 Application pg_waldump display a human-readable rendering of the write-ahead log of... 4 小时前
    192. 1.192 pg_walsummary pg_walsummary pg_walsummary 1 Application pg_walsummary print contents of WAL summary files pg_walsummary o... 4 小时前
    193. 1.193 pgarchivecleanup pg_archivecleanup pg_archivecleanup 1 Application pg_archivecleanup clean up PostgreSQL WAL archive files p... 4 小时前
    194. 1.194 pgbench pgbench pgbench 1 Application pgbench run a benchmark test on PostgreSQL pgbench -i option dbname pgbench o... 4 小时前
    195. 1.195 pgtestfsync pg_test_fsync pg_test_fsync 1 Application pg_test_fsync determine fastest wal_sync_method for PostgreSQL pg... 4 小时前
    196. 1.196 pgtesttiming pg_test_timing pg_test_timing 1 Application pg_test_timing measure timing overhead pg_test_timing option De... 4 小时前
    197. 1.197 postgres-ref postgres postgres 1 Application postgres PostgreSQL database server postgres option Description postgres is... 4 小时前
    198. 1.198 prepare PREPARE prepared statements creating PREPARE 7 SQL - Language Statements PREPARE prepare a statement for ex... 4 小时前
    199. 1.199 prepare_transaction PREPARE TRANSACTION PREPARE TRANSACTION 7 SQL - Language Statements PREPARE TRANSACTION prepare the current... 4 小时前
    200. 1.200 reassign_owned REASSIGN OWNED REASSIGN OWNED 7 SQL - Language Statements REASSIGN OWNED change the ownership of database o... 4 小时前
    201. 1.201 refresh_materialized_view REFRESH MATERIALIZED VIEW REFRESH MATERIALIZED VIEW 7 SQL - Language Statements REFRESH MATERIALIZED VIEW r... 4 小时前
    202. 1.202 reindex REINDEX REINDEX 7 SQL - Language Statements REINDEX rebuild indexes REINDEX [ ( option [, ...] ) ] { INDEX ... 4 小时前
    203. 1.203 reindexdb reindexdb reindexdb 1 Application reindexdb reindex a PostgreSQL database reindexdb connection-option optio... 4 小时前
    204. 1.204 release_savepoint RELEASE SAVEPOINT savepoints releasing RELEASE SAVEPOINT 7 SQL - Language Statements RELEASE SAVEPOINT rele... 4 小时前
    205. 1.205 repack REPACK REPACK 7 SQL - Language Statements REPACK rewrite a table to reclaim disk space REPACK [ ( option [,... 4 小时前
    206. 1.206 reset RESET RESET 7 SQL - Language Statements RESET restore the value of a run-time parameter to the default valu... 4 小时前
    207. 1.207 revoke REVOKE REVOKE 7 SQL - Language Statements REVOKE remove access privileges REVOKE [ GRANT OPTION FOR ] { { S... 4 小时前
    208. 1.208 rollback ROLLBACK ROLLBACK 7 SQL - Language Statements ROLLBACK abort the current transaction ROLLBACK [ WORK | TRAN... 4 小时前
    209. 1.209 rollback_prepared ROLLBACK PREPARED ROLLBACK PREPARED 7 SQL - Language Statements ROLLBACK PREPARED cancel a transaction that... 4 小时前
    210. 1.210 rollback_to ROLLBACK TO SAVEPOINT savepoints rolling back ROLLBACK TO SAVEPOINT 7 SQL - Language Statements ROLLBACK TO... 4 小时前
    211. 1.211 savepoint SAVEPOINT savepoints defining SAVEPOINT 7 SQL - Language Statements SAVEPOINT define a new savepoint within... 4 小时前
    212. 1.212 security_label SECURITY LABEL SECURITY LABEL 7 SQL - Language Statements SECURITY LABEL define or change a security label ... 4 小时前
    213. 1.213 select SELECT TABLE command WITH in SELECT SELECT 7 SQL - Language Statements SELECT TABLE WITH retrieve rows from... 4 小时前
    214. 1.214 select_into SELECT INTO SELECT INTO 7 SQL - Language Statements SELECT INTO define a new table from the results of a qu... 4 小时前
    215. 1.215 set SET SET 7 SQL - Language Statements SET change a run-time parameter SET [ SESSION | LOCAL ] configuration_p... 4 小时前
    216. 1.216 set_constraints SET CONSTRAINTS SET CONSTRAINTS 7 SQL - Language Statements SET CONSTRAINTS set constraint check timing for... 4 小时前
    217. 1.217 set_role SET ROLE SET ROLE 7 SQL - Language Statements SET ROLE set the current user identifier of the current sessi... 4 小时前
    218. 1.218 set_session_auth SET SESSION AUTHORIZATION SET SESSION AUTHORIZATION 7 SQL - Language Statements SET SESSION AUTHORIZATION s... 4 小时前
    219. 1.219 set_transaction SET TRANSACTION transaction isolation level setting read-only transaction setting deferrable transaction se... 4 小时前
    220. 1.220 show SHOW SHOW 7 SQL - Language Statements SHOW show the value of a run-time parameter SHOW name SHOW ALL Descri... 4 小时前
    221. 1.221 start_transaction START TRANSACTION START TRANSACTION 7 SQL - Language Statements START TRANSACTION start a transaction block... 4 小时前
    222. 1.222 truncate TRUNCATE TRUNCATE 7 SQL - Language Statements TRUNCATE empty a table or set of tables TRUNCATE [ TABLE ] [ ... 4 小时前
    223. 1.223 unlisten UNLISTEN UNLISTEN 7 SQL - Language Statements UNLISTEN stop listening for a notification UNLISTEN { channel... 4 小时前
    224. 1.224 update UPDATE UPDATE 7 SQL - Language Statements UPDATE update rows of a table [ WITH [ RECURSIVE ] with_query [, ... 4 小时前
    225. 1.225 vacuum VACUUM VACUUM 7 SQL - Language Statements VACUUM garbage-collect and optionally analyze a database VACUUM [... 4 小时前
    226. 1.226 vacuumdb vacuumdb vacuumdb 1 Application vacuumdb garbage-collect and analyze a PostgreSQL database vacuumdb connect... 4 小时前
    227. 1.227 values VALUES VALUES 7 SQL - Language Statements VALUES compute a set of rows VALUES ( expression [, ...] ) [, ...... 4 小时前
    228. 1.228 wait WAIT WAIT 7 SQL - Language Statements WAIT wait for WAL to reach a target LSN WAIT FOR LSN ' lsn ' [ WITH (... 4 小时前
    229. 1.229 Database Roles PostgreSQL manages database access permissions using the concept of roles. A role can be thought of as eith... 4 小时前
    230. 1.230 Reliability and the Write-Ahead Log This chapter explains how to control the reliability of PostgreSQL, including details about the Write-Ahead... 4 小时前