PostgreSQL 正體中文使用手冊
16
PostgreSQL.TW
官方使用手冊
小島故事
加入社團
Search
⌃
K
Links
簡介
前言
I. 新手教學
II. SQL 查詢語言
III. 系統管理
IV. 用戶端介面
V. 資料庫程式設計
VI. 參考資訊
I. SQL 指令
ALTER DATABASE
ALTER DEFAULT PRIVILEGES
ALTER EXTENSION
ALTER FUNCTION
ALTER INDEX
ALTER LANGUAGE
ALTER MATERIALIZED VIEW
ALTER POLICY
ALTER PUBLICATION
ALTER ROLE
ALTER RULE
ALTER SCHEMA
ALTER SEQUENCE
ALTER STATISTICS
ALTER SUBSCRIPTION
ALTER SYSTEM
ALTER TABLE
ALTER TABLESPACE
ALTER TRIGGER
ALTER TYPE
ALTER USER
ALTER VIEW
ANALYZE
CLUSTER
COMMENT
COMMIT PREPARED
COPY
CREATE ACCESS METHOD
CREATE CAST
CREATE DATABASE
CREATE EVENT TRIGGER
CREATE EXTENSION
CREATE FOREIGN TABLE
CREATE FOREIGN DATA WRAPPER
CREATE FUNCTION
CREATE INDEX
CREATE LANGUAGE
CREATE MATERIALIZED VIEW
CREATE DOMAIN
CREATE POLICY
CREATE PROCEDURE
CREATE PUBLICATION
CREATE ROLE
CREATE RULE
CREATE SCHEMA
CREATE SEQUENCE
CREATE SERVER
CREATE STATISTICS
CREATE SUBSCRIPTION
CREATE TABLE
CREATE TABLE AS
CREATE TABLESPACE
CREATE TRANSFORM
CREATE TRIGGER
CREATE TYPE
CREATE USER
CREATE USER MAPPING
CREATE VIEW
DEALLOCATE
DELETE
DO
DROP ACCESS METHOD
DROP DATABASE
DROP EXTENSION
DROP FUNCTION
DROP INDEX
DROP LANGUAGE
DROP MATERIALIZED VIEW
DROP OWNED
DROP POLICY
DROP PUBLICATION
DROP ROLE
DROP RULE
DROP SCHEMA
DROP SEQUENCE
DROP STATISTICS
DROP SUBSCRIPTION
DROP TABLE
DROP TABLESPACE
DROP TRANSFORM
DROP TRIGGER
DROP TYPE
DROP USER
DROP VIEW
EXECUTE
EXPLAIN
GRANT
IMPORT FOREIGN SCHEMA
INSERT
LISTEN
LOAD
MERGE
NOTIFY
PREPARE
PREPARE TRANSACTION
REASSIGN OWNED
REFRESH MATERIALIZED VIEW
REINDEX
RESET
REVOKE
ROLLBACK PREPARED
SECURITY LABEL
SELECT
SELECT INTO
SET
SET CONSTRAINTS
SET ROLE
SET SESSION AUTHORIZATION
SET TRANSACTION
SHOW
TRUNCATE
UNLISTEN
UPDATE
VACUUM
VALUES
II. PostgreSQL 用戶端工具
III. PostgreSQL 伺服器應用程式
VII. 資料庫進階
VIII. 附錄
參考書目
Powered By
GitBook
I. SQL 指令
本部分包含 PostgreSQL 支援的 SQL 指令的參考訊息。一般而言,「SQL」是指語 言;內容包含了有關各標準的一致性和相容性。
連結將會連結至 PostgreSQL 官方使用手冊,本手冊連結請使用左側目錄。
Table of Contents
ABORT
— abort the current transaction
ALTER AGGREGATE
— change the definition of an aggregate function
ALTER COLLATION
— change the definition of a collation
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 EVENT TRIGGER
— change the definition of an event trigger
ALTER EXTENSION
— change the definition of an extension
ALTER FOREIGN DATA WRAPPER
— change the definition of a foreign-data wrapper
ALTER FOREIGN TABLE
— change the definition of a foreign table
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 MATERIALIZED VIEW
— change the definition of a materialized view
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 POLICY
— change the definition of a row-level security policy
ALTER PROCEDURE
— change the definition of a procedure
ALTER PUBLICATION
— change the definition of a publication
ALTER ROLE
— change a database role
ALTER ROUTINE
— change the definition of a routine