I. SQL 指令
Last updated
Was this helpful?
Last updated
Was this helpful?
本部分包含 PostgreSQL 支援的 SQL 指令的參考訊息。一般而言,「SQL」是指語言;內容包含了有關各標準的一致性和相容性。
連結將會連結至 PostgreSQL 官方使用手冊,本手冊連結請使用左側目錄。
Table of Contents
— abort the current transaction ** — change the definition of an aggregate function — change the definition of a collation — change the definition of a conversion — change a database — define default access privileges — change the definition of a domain — change the definition of an event trigger — change the definition of an extension — change the definition of a foreign-data wrapper — change the definition of a foreign table — change the definition of a function — change role name or membership — change the definition of an index — change the definition of a procedural language — change the definition of a large object — change the definition of a materialized view — change the definition of an operator — change the definition of an operator class — change the definition of an operator family — change the definition of a row level security policy — change the definition of a procedure — change the definition of a publication — change a database role — change the definition of a routine — change the definition of a rule — change the definition of a schema — change the definition of a sequence generator — change the definition of a foreign server — change the definition of an extended statistics object — change the definition of a subscription — change a server configuration parameter — change the definition of a table — change the definition of a tablespace — change the definition of a text search configuration — change the definition of a text search dictionary — change the definition of a text search parser — change the definition of a text search template — change the definition of a trigger — change the definition of a type — change a database role — change the definition of a user mapping — change the definition of a view — collect statistics about a database — start a transaction block — invoke a procedure — force a write-ahead log checkpoint — close a cursor — cluster a table according to an index — define or change the comment of an object — commit the current transaction — commit a transaction that was earlier prepared for two-phase commit — copy data between a file and a table — define a new access method — define a new aggregate function — define a new cast — define a new collation — define a new encoding conversion — create a new database — define a new domain — define a new event trigger — install an extension — define a new foreign-data wrapper — define a new foreign table — define a new function — define a new database role — define a new index — define a new procedural language — define a new materialized view — define a new operator — define a new operator class — define a new operator family — define a new row level security policy for a table — define a new procedure — define a new publication — define a new database role — define a new rewrite rule — define a new schema — define a new sequence generator — define a new foreign server — define extended statistics — define a new subscription — define a new table — define a new table from the results of a query — define a new tablespace — define a new text search configuration — define a new text search dictionary — define a new text search parser — define a new text search template — define a new transform — define a new trigger — define a new data type — define a new database role — define a new mapping of a user to a foreign server — define a new view — deallocate a prepared statement — define a cursor — delete rows of a table — discard session state — execute an anonymous code block — remove an access method — remove an aggregate function — remove a cast — remove a collation — remove a conversion — remove a database — remove a domain — remove an event trigger — remove an extension — remove a foreign-data wrapper — remove a foreign table — remove a function — remove a database role — remove an index — remove a procedural language — remove a materialized view — remove an operator — remove an operator class — remove an operator family — remove database objects owned by a database role — remove a row level security policy from a table — remove a procedure — remove a publication — remove a database role — remove a routine — remove a rewrite rule — remove a schema — remove a sequence — remove a foreign server descriptor — remove extended statistics — remove a subscription — remove a table — remove a tablespace — remove a text search configuration — remove a text search dictionary — remove a text search parser — remove a text search template — remove a transform — remove a trigger — remove a data type — remove a database role — remove a user mapping for a foreign server — remove a view — commit the current transaction — execute a prepared statement — show the execution plan of a statement — retrieve rows from a query using a cursor — define access privileges — import table definitions from a foreign server — create new rows in a table — listen for a notification — load a shared library file — lock a table — position a cursor — generate a notification — prepare a statement for execution — prepare the current transaction for two-phase commit — change the ownership of database objects owned by a database role — replace the contents of a materialized view — rebuild indexes — destroy a previously defined savepoint — restore the value of a run-time parameter to the default value — remove access privileges — abort the current transaction — cancel a transaction that was earlier prepared for two-phase commit — roll back to a savepoint — define a new savepoint within the current transaction — define or change a security label applied to an object — retrieve rows from a table or view — define a new table from the results of a query — change a run-time parameter — set constraint check timing for the current transaction — set the current user identifier of the current session — set the session user identifier and the current user identifier of the current session — set the characteristics of the current transaction — show the value of a run-time parameter — start a transaction block — empty a table or set of tables — stop listening for a notification — update rows of a table — garbage-collect and optionally analyze a database — compute a set of rows