快速开始快速开始产品指南产品指南SQL 参考SQL 参考发布与公告发布与公告管控台 ↗管控台 ↗ (opens in a new tab)
  • Part I. Tutorial
    • The SQL Language
      • Introduction
      • Concepts
      • Creating a New Table
      • Populating a Table With Rows
      • Querying a Table
      • Joins Between Tables
      • Aggregate Functions
      • Updates
      • Deletions
    • Advanced Features
      • Introduction
      • Views
      • Foreign Keys
      • Transactions
      • Window Functions
      • Conclusion
  • Part II. The SQL Language
    • SQL Syntax
      • Lexical Structure
      • Value Expressions
      • Calling Functions
    • Data Definition
      • Table Basics
      • Default Values
      • Generated Columns
      • Constraints
      • System Columns
      • Modifying Tables
      • Privileges
      • Row Security Policies
      • Schemas
      • Foreign Data
      • Other Database Objects
      • Dependency Tracking
    • Data Manipulation
      • Inserting Data
      • Updating Data
      • Deleting Data
      • Returning Data from Modified Rows
    • Queries
      • Overview
      • Table Expressions
      • Select Lists
      • Combining Queries (UNION, INTERSECT, EXCEPT)
      • Sorting Rows (ORDER BY)
      • LIMIT and OFFSET
      • VALUES Lists
      • WITH Queries (Common Table Expressions)
    • Data Type
      • Numeric Types
      • Character Types
      • Binary Data Types
      • Date/Time Types
      • Boolean Type
      • Enumerated Types
      • Network Address Types
      • Bit String Types
      • Text Search Types
      • UUID Type
      • JSON Types
      • Arrays
      • Object Identifier Types
    • Functions and Operators
      • Logical Operators
      • Comparison Functions and Operators
      • Mathematical Functions and Operators
      • String Functions and Operators
      • Binary String Functions and Operators
      • Bit String Functions and Operators
      • Pattern Matching
      • Data Type Formatting Functions
      • Date/Time Functions and Operators
      • Enum Support Functions
      • Network Address Functions and Operators
      • UUID Functions
      • JSON Functions and Operators
      • Sequence Manipulation Functions
      • Conditional Expressions
      • Array Functions and Operators
      • Aggregate Functions
      • Window Functions
      • Subquery Expressions
      • Row and Array Comparisons
      • Set Returning Functions
      • System Information Functions and Operators
      • System Administration Functions
    • Type Conversion
      • Chapter Type Conversion
      • Overview
      • Operators
      • Functions
      • Value Storage
      • UNION, CASE, and Related Constructs
      • SELECT Output Columns
  • Part III. Server Administration
    • Managing Databases
      • Overview
      • Creating a Database
      • Template Databases
      • Database Configuration
      • Destroying a Database
      • Tablespaces
    • Monitoring Database Activity
      • The Statistics Collector
      • Progress Reporting
  • Part IV. Reference
    • SQL Commands
      • ABORT
      • ALTER DATABASE
      • ALTER DEFAULT PRIVILEGES
      • ALTER EXTENSION
      • ALTER FOREIGN DATA WRAPPER
      • ALTER FOREIGN TABLE
      • ALTER MATERIALIZED VIEW
      • ALTER POLICY
      • ALTER SCHEMA
      • ALTER SEQUENCE
      • ALTER SERVER
      • ALTER TABLE
      • ALTER USER MAPPING
      • ALTER VIEW
      • ANALYZE
      • BEGIN
      • CHECKPOINT
      • COMMENT
      • COMMIT
      • COPY
      • CREATE DATABASE
      • CREATE EXTENSION
      • CREATE FOREIGN DATA WRAPPER
      • CREATE FOREIGN TABLE
      • CREATE MATERIALIZED VIEW
      • CREATE POLICY
      • CREATE SCHEMA
      • CREATE SEQUENCE
      • CREATE SERVER
      • CREATE TABLE
      • CREATE TABLE AS
      • CREATE USER MAPPING
      • CREATE VIEW
      • DEALLOCATE
      • DELETE
      • DISCARD
      • DROP DATABASE
      • DROP EXTENSION
      • DROP FOREIGN DATA WRAPPER
      • DROP FOREIGN TABLE
      • DROP MATERIALIZED VIEW
      • DROP POLICY
      • DROP SCHEMA
      • DROP SEQUENCE
      • DROP SERVER
      • DROP TABLE
      • DROP USER MAPPING
      • DROP VIEW
      • END
      • EXECUTE
      • EXPLAIN
      • GRANT
      • IMPORT FOREIGN SCHEMA
      • INSERT
      • MERGE
      • PREPARE
      • REASSIGN OWNED
      • REFRESH MATERIALIZED VIEW
      • REINDEX
      • RELEASE SAVEPOINT
      • RESET
      • REVOKE
      • ROLLBACK
      • ROLLBACK TO SAVEPOINT
      • SAVEPOINT
      • SELECT
      • SELECT INTO
      • SET
      • SET ROLE
      • SET TRANSACTION
      • SHOW
      • START TRANSACTION
      • TRUNCATE
      • UPDATE
      • VALUES
    • Client Applications
      • psql
  • Part V. Internals
    • System Catalogs
      • Overview
      • pg_aggregate
      • pg_attrdef
      • pg_attribute
      • pg_authid
      • pg_auth_members
      • pg_cast
      • pg_class
      • pg_collation
      • pg_constraint
      • pg_conversion
      • pg_database
      • pg_db_role_setting
      • pg_default_acl
      • pg_depend
      • pg_description
      • pg_enum
      • pg_event_trigger
      • pg_extension
      • pg_foreign_data_wrapper
      • pg_foreign_server
      • pg_foreign_table
      • pg_index
      • pg_inherits
      • pg_language
      • pg_namespace
      • pg_operator
      • pg_policy
      • pg_proc
      • pg_range
      • pg_rewrite
      • pg_seclabel
      • pg_sequence
      • pg_shdepend
      • pg_shdescription
      • pg_shseclabel
      • pg_tablespace
      • pg_type
      • System Views
      • pg_available_extensions
      • pg_indexes
      • pg_locks
      • pg_matviews
      • pg_prepared_statements
      • pg_prepared_xacts
      • pg_roles
      • pg_seclabels
      • pg_settings
      • pg_shadow
      • pg_tables
      • pg_user
      • pg_views
  • Part VI. Appendixes
    • A. Warebase Error Codes
    • B. Date/Time Support
      • B.1. Date/Time Input Interpretation
      • B.2. Handling of Invalid or Ambiguous Timestamps
      • B.3. Date/Time Key Words
      • B.4. Date/Time Configuration Files
      • B.5. POSIX Time Zone Specifications
      • B.6. History of Units
      • B.7. Julian Dates
    • C. SQL Keywords
  • Legal Notice

目录

  • Chapter Advanced Features
SQL 参考
Part I. Tutorial
Advanced Features

Chapter Advanced Features

Table of Contents

Introduction

Views

Foreign Keys

Transactions

Window Functions

Conclusion

DeletionsIntroduction
© 2024 ProtonBase All rights reserved.