SQL 命令

SQL 命令

这部分包含PostgreSQL支持的SQL命令的参考信息。每条命令的标准符合和兼容的信息可以在相关的参考页中找到。

• ABORT
• ALTER AGGREGATE
• ALTER COLLATION
• ALTER CONVERSION
• ALTER DATABASE
• ALTER DEFAULT PRIVILEGES
• ALTER EVENT TRIGGER
• ALTER EXTENSION
• ALTER FOREIGN DATA WRAPPER
• ALTER FOREIGN TABLE
• ALTER FUNCTION
• ALTER GROUP
• ALTER INDEX
• ALTER LANGUAGE
• ALTER LARGE OBJECT
• ALTER MATERIALIZED VIEW
• ALTER OPERATOR
• ALTER OPERATOR CLASS
• ALTER OPERATOR FAMILY
• ALTER POLICY
• ALTER PROCEDURE
• ALTER PUBLICATION
• ALTER RESOURCE QUEUE
• ALTER ROLE
• ALTER ROUTINE
• ALTER RULE
• ALTER SCHEMA
• ALTER SEQUENCE
• ALTER SERVER
• ALTER STATISTICS
• ALTER SUBSCRIPTION
• ALTER SYSTEM
• ALTER TABLE
• ALTER TABLESPACE
• ALTER TRIGGER
• ALTER TYPE
• ALTER USER
• ALTER USER MAPPING
• ALTER VIEW
• ANALYZE
• BEGIN
• CALL
• CHECKPOINT
• CLOSE
• COMMENT
• COMMIT
• COMPACT
• COPY
• CREATE AGGREGATE
• CREATE CAST
• CREATE COLLATION
• CREATE CONVERSION
• CREATE DATABASE
• CREATE EVENT TRIGGER
• CREATE EXTENSION
• CREATE FOREIGN DATA WRAPPER
• CREATE FOREIGN TABLE
• CREATE FUNCTION
• CREATE GROUP
• CREATE INDEX
• CREATE LANGUAGE
• CREATE MATERIALIZED VIEW
• CREATE OPERATOR
• CREATE OPERATOR CLASS
• CREATE OPERATOR FAMILY
• CREATE POLICY
• CREATE PROCEDURE
• CREATE PUBLICATION
• CREATE RESOURCE QUEUE
• 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
• DECLARE
• DELETE
• DISCARD
• DO
• DROP ACCESS METHOD
• DROP AGGREGATE
• DROP CAST
• DROP COLLATION
• DROP CONVERSION
• DROP DATABASE
• DROP EVENT TRIGGER
• DROP EXTENSION
• DROP FOREIGN DATA WRAPPER
• DROP FOREIGN TABLE
• DROP FUNCTION
• DROP GROUP
• DROP INDEX
• DROP LANGUAGE
• DROP MATERIALIZED VIEW
• DROP OPERATOR
• DROP OPERATOR CLASS
• DROP OPERATOR FAMILY
• DROP OWNED
• DROP POLICY
• DROP PROCEDURE
• DROP PUBLICATION
• DROP RESOURCE QUEUE
• DROP ROLE
• DROP ROUTINE
• DROP RULE
• DROP SCHEMA
• DROP SEQUENCE
• DROP SERVER
• DROP STATISTICS
• DROP SUBSCRIPTION
• DROP TABLE
• DROP TABLESPACE
• DROP TRANSFORM
• DROP TRIGGER
• DROP TYPE
• DROP USER
• DROP USER MAPPING
• DROP VIEW
• END
• EXECUTE
• EXPLAIN
• FETCH
• GRANT
• IMPORT FOREIGN SCHEMA
• INSERT
• LOAD
• LOCK
• MOVE
• PREPARE
• REASSIGN OWNED
• REFRESH MATERIALIZED VIEW
• REINDEX
• RELEASE SAVEPOINT
• RESET
• REVOKE
• ROLLBACK
• ROLLBACK TO SAVEPOINT
• SAVEPOINT
• SECURITY LABEL
• SELECT
• SELECT INTO
• SET
• SET ROLE
• SET SESSION AUTHORIZATION
• SHOW
• START TRANSACTION
• TRUNCATE
• UPDATE
• VALUES