跳转到主要内容

章节PostgreSQL 文档

Doc

230 页更新于 1 天前

开始阅读

本章内容230

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