comment(7)

COMMENT ON
{
\n
  ACCESS METHOD \nobject_name\n |
\n
  AGGREGATE \naggregate_name\n ( \naggregate_signature\n ) |
\n
  CAST (\nsource_type\n AS \ntarget_type\n) |
\n
  COLLATION \nobject_name\n |
\n
  COLUMN \nrelation_name\n.\ncolumn_name\n |
\n
  CONSTRAINT \nconstraint_name\n ON \ntable_name\n |
\n
  CONSTRAINT \nconstraint_name\n ON DOMAIN \ndomain_name\n |
\n
  CONVERSION \nobject_name\n |
\n
  DATABASE \nobject_name\n |
\n
  DOMAIN \nobject_name\n |
\n
  EXTENSION \nobject_name\n |
\n
  EVENT TRIGGER \nobject_name\n |
\n
  FOREIGN DATA WRAPPER \nobject_name\n |
\n
  FOREIGN TABLE \nobject_name\n |
\n
  FUNCTION \nfunction_name\n [ ( [ [ \nargmode\n ] [ \nargname\n ] \nargtype\n [, ...] ] ) ] |
\n
  INDEX \nobject_name\n |
\n
  LARGE OBJECT \nlarge_object_oid\n |
\n
  MATERIALIZED VIEW \nobject_name\n |
\n
  OPERATOR \noperator_name\n (\nleft_type\n, \nright_type\n) |
\n
  OPERATOR CLASS \nobject_name\n USING \nindex_method\n |
\n
  OPERATOR FAMILY \nobject_name\n USING \nindex_method\n |
\n
  POLICY \npolicy_name\n ON \ntable_name\n |
\n
  [ PROCEDURAL ] LANGUAGE \nobject_name\n |
\n
  PROCEDURE \nprocedure_name\n [ ( [ [ \nargmode\n ] [ \nargname\n ] \nargtype\n [, ...] ] ) ] |
\n
  PUBLICATION \nobject_name\n |
\n
  ROLE \nobject_name\n |
\n
  ROUTINE \nroutine_name\n [ ( [ [ \nargmode\n ] [ \nargname\n ] \nargtype\n [, ...] ] ) ] |
\n
  RULE \nrule_name\n ON \ntable_name\n |
\n
  SCHEMA \nobject_name\n |
\n
  SEQUENCE \nobject_name\n |
\n
  SERVER \nobject_name\n |
\n
  STATISTICS \nobject_name\n |
\n
  SUBSCRIPTION \nobject_name\n |
\n
  TABLE \nobject_name\n |
\n
  TABLESPACE \nobject_name\n |
\n
  TEXT SEARCH CONFIGURATION \nobject_name\n |
\n
  TEXT SEARCH DICTIONARY \nobject_name\n |
\n
  TEXT SEARCH PARSER \nobject_name\n |
\n
  TEXT SEARCH TEMPLATE \nobject_name\n |
\n
  TRANSFORM FOR \ntype_name\n LANGUAGE \nlang_name\n |
\n
  TRIGGER \ntrigger_name\n ON \ntable_name\n |
\n
  TYPE \nobject_name\n |
\n
  VIEW \nobject_name\n
} IS { \nstring_literal\n | NULL }
where \naggregate_signature\n is:
* |
[ \nargmode\n ] [ \nargname\n ] \nargtype\n [ , ... ] |
[ [ \nargmode\n ] [ \nargname\n ] \nargtype\n [ , ... ] ] ORDER BY [ \nargmode\n ] [ \nargname\n ] \nargtype\n [ , ... ]

COMMENT ON TABLE mytable IS 'This is my table.';

COMMENT ON TABLE mytable IS NULL;

COMMENT ON ACCESS METHOD gin IS 'GIN index access method';
COMMENT ON AGGREGATE my_aggregate (double precision) IS 'Computes sample variance';
COMMENT ON CAST (text AS int4) IS 'Allow casts from text to int4';
COMMENT ON COLLATION "fr_CA" IS 'Canadian French';
COMMENT ON COLUMN my_table.my_column IS 'Employee ID number';
COMMENT ON CONVERSION my_conv IS 'Conversion to UTF8';
COMMENT ON CONSTRAINT bar_col_cons ON bar IS 'Constrains column col';
COMMENT ON CONSTRAINT dom_col_constr ON DOMAIN dom IS 'Constrains col of domain';
COMMENT ON DATABASE my_database IS 'Development Database';
COMMENT ON DOMAIN my_domain IS 'Email Address Domain';
COMMENT ON EVENT TRIGGER abort_ddl IS 'Aborts all DDL commands';
COMMENT ON EXTENSION hstore IS 'implements the hstore data type';
COMMENT ON FOREIGN DATA WRAPPER mywrapper IS 'my foreign data wrapper';
COMMENT ON FOREIGN TABLE my_foreign_table IS 'Employee Information in other database';
COMMENT ON FUNCTION my_function (timestamp) IS 'Returns Roman Numeral';
COMMENT ON INDEX my_index IS 'Enforces uniqueness on employee ID';
COMMENT ON LANGUAGE plpython IS 'Python support for stored procedures';
COMMENT ON LARGE OBJECT 346344 IS 'Planning document';
COMMENT ON MATERIALIZED VIEW my_matview IS 'Summary of order history';
COMMENT ON OPERATOR ^ (text, text) IS 'Performs intersection of two texts';
COMMENT ON OPERATOR - (NONE, integer) IS 'Unary minus';
COMMENT ON OPERATOR CLASS int4ops USING btree IS '4 byte integer operators for btrees';
COMMENT ON OPERATOR FAMILY integer_ops USING btree IS 'all integer operators for btrees';
COMMENT ON POLICY my_policy ON mytable IS 'Filter rows by users';
COMMENT ON PROCEDURE my_proc (integer, integer) IS 'Runs a report';
COMMENT ON PUBLICATION alltables IS 'Publishes all operations on all tables';
COMMENT ON ROLE my_role IS 'Administration group for finance tables';
COMMENT ON ROUTINE my_routine (integer, integer) IS 'Runs a routine (which is a function or procedure)';
COMMENT ON RULE my_rule ON my_table IS 'Logs updates of employee records';
COMMENT ON SCHEMA my_schema IS 'Departmental data';
COMMENT ON SEQUENCE my_sequence IS 'Used to generate primary keys';
COMMENT ON SERVER myserver IS 'my foreign server';
COMMENT ON STATISTICS my_statistics IS 'Improves planner row estimations';
COMMENT ON SUBSCRIPTION alltables IS 'Subscription for all operations on all tables';
COMMENT ON TABLE my_schema.my_table IS 'Employee Information';
COMMENT ON TABLESPACE my_tablespace IS 'Tablespace for indexes';
COMMENT ON TEXT SEARCH CONFIGURATION my_config IS 'Special word filtering';
COMMENT ON TEXT SEARCH DICTIONARY swedish IS 'Snowball stemmer for Swedish language';
COMMENT ON TEXT SEARCH PARSER my_parser IS 'Splits text into words';
COMMENT ON TEXT SEARCH TEMPLATE snowball IS 'Snowball stemmer';
COMMENT ON TRANSFORM FOR hstore LANGUAGE plpython3u IS 'Transform between hstore and Python dict';
COMMENT ON TRIGGER my_trigger ON my_table IS 'Used for RI';
COMMENT ON TYPE complex IS 'Complex number data type';
COMMENT ON VIEW my_view IS 'View of departmental costs';