SQL: PostgreSQL specific extensions

  • SQL compliance vs. useful features/implementations

  • Schema manipulation
    • CREATE [WITH OWNER]/ALTER DATABASE
    • CREATE INDEX
    • CREATE OPERATOR [CLASS]
    • CREATE TABLE AS
    • CREATE TYPE
    • CREATE SEQUENCE
    • CREATE AGGREGATE
    • COPY
    • COMMENT
    • TRUNCATE

  • Query rewriting
    • CREATE RULE

  • Privileges
    • CREATE USER
    • CREATE GROUP
    Prev

    Next

    Page 26