Skip to main content

Documentation Index

Fetch the complete documentation index at: https://www.pgschema.com/llms.txt

Use this file to discover all available pages before exploring further.

​
Syntax

comment_on ::= COMMENT ON object_type object_name IS 'comment_text'
             | COMMENT ON object_type object_name IS NULL

object_type ::= COLUMN | FUNCTION | INDEX | MATERIALIZED VIEW | PROCEDURE | TABLE | VIEW

object_name ::= [schema.]name
              | [schema.]table_name.column_name                -- for columns
              | [schema.]function_name(argument_types)         -- for functions
              | [schema.]procedure_name(argument_types)        -- for procedures
COMMENT ON is supported for the following objects:
  • Column
  • Function
  • Index
  • Materialized View
  • Procedure
  • Table
  • View