Extensions

• CREATE EXTENSION
  • IF NOT EXISTS
  • extension_name
  • WITH
  • SCHEMA schema_name
  • VERSION version
  • CASCADE
• ALTER EXTENSION
  • name
  • UPDATE [ TO new_version ]
  • SET SCHEMA new_schema
  • {ADD | DROP} member_object where member_object is:
    • ACCESS METHOD object_name
    • AGGREGATE aggregate_name ( aggregate_signature ), where aggregate_signature is:
      • *
      • [ argmode ] [ argname ] argtype [ , ... ]
      • [ [ argmode ] [ argname ] argtype [ , ... ] ] ORDER BY [ argmode ] [ argname ] argtype [ , ... ]
    • CAST (source_type AS target_type)
    • COLLATION object_name
    • CONVERSION object_name
    • DOMAIN object_name
    • EVENT TRIGGER object_name
    • FOREIGN DATA WRAPPER object_name
    • FOREIGN TABLE object_name
    • FUNCTION function_name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ]
    • MATERIALIZED VIEW object_name
    • OPERATOR operator_name (left_type, right_type)
    • OPERATOR CLASS object_name USING index_method
    • OPERATOR FAMILY object_name USING index_method
    • [ PROCEDURAL ] LANGUAGE object_name
    • PROCEDURE procedure_name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ]
    • ROUTINE routine_name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ]
    • SCHEMA object_name
    • SEQUENCE object_name
    • SERVER object_name
    • TABLE object_name
    • TEXT SEARCH CONFIGURATION object_name
    • TEXT SEARCH DICTIONARY object_name
    • TEXT SEARCH PARSER object_name
    • TEXT SEARCH TEMPLATE object_name
    • TRANSFORM FOR type_name LANGUAGE lang_name
    • TYPE object_name
    • VIEW object_name
• DROP EXTENSION
  • IF EXISTS
  • name, ...
  • CASCADE | RESTRICT