Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commitbfd78c0

Browse files
committed
docs: add COMMENT examples for new features, rename rtree
Reported-by: Jürgen PurtzDiscussion:https://postgr.es/m/15ec5428-d46a-1725-f38d-44986a977abb@purtz.deAuthor: Jürgen PurtzBackpatch-through: 11
1 parent5028981 commitbfd78c0

File tree

1 file changed

+5
-1
lines changed

1 file changed

+5
-1
lines changed

‎doc/src/sgml/ref/comment.sgml

Lines changed: 5 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -306,7 +306,7 @@ COMMENT ON TABLE mytable IS NULL;
306306
Some more examples:
307307

308308
<programlisting>
309-
COMMENT ON ACCESS METHODrtree IS 'R-Tree access method';
309+
COMMENT ON ACCESS METHODgin IS 'GIN index access method';
310310
COMMENT ON AGGREGATE my_aggregate (double precision) IS 'Computes sample variance';
311311
COMMENT ON CAST (text AS int4) IS 'Allow casts from text to int4';
312312
COMMENT ON COLLATION "fr_CA" IS 'Canadian French';
@@ -316,6 +316,7 @@ COMMENT ON CONSTRAINT bar_col_cons ON bar IS 'Constrains column col';
316316
COMMENT ON CONSTRAINT dom_col_constr ON DOMAIN dom IS 'Constrains col of domain';
317317
COMMENT ON DATABASE my_database IS 'Development Database';
318318
COMMENT ON DOMAIN my_domain IS 'Email Address Domain';
319+
COMMENT ON EVENT TRIGGER abort_ddl IS 'Aborts all DDL commands';
319320
COMMENT ON EXTENSION hstore IS 'implements the hstore data type';
320321
COMMENT ON FOREIGN DATA WRAPPER mywrapper IS 'my foreign data wrapper';
321322
COMMENT ON FOREIGN TABLE my_foreign_table IS 'Employee Information in other database';
@@ -330,12 +331,15 @@ COMMENT ON OPERATOR CLASS int4ops USING btree IS '4 byte integer operators for b
330331
COMMENT ON OPERATOR FAMILY integer_ops USING btree IS 'all integer operators for btrees';
331332
COMMENT ON POLICY my_policy ON mytable IS 'Filter rows by users';
332333
COMMENT ON PROCEDURE my_proc (integer, integer) IS 'Runs a report';
334+
COMMENT ON PUBLICATION alltables IS 'Publishes all operations on all tables';
333335
COMMENT ON ROLE my_role IS 'Administration group for finance tables';
336+
COMMENT ON ROUTINE my_routine (integer, integer) IS 'Runs a routine (which is a function or procedure)';
334337
COMMENT ON RULE my_rule ON my_table IS 'Logs updates of employee records';
335338
COMMENT ON SCHEMA my_schema IS 'Departmental data';
336339
COMMENT ON SEQUENCE my_sequence IS 'Used to generate primary keys';
337340
COMMENT ON SERVER myserver IS 'my foreign server';
338341
COMMENT ON STATISTICS my_statistics IS 'Improves planner row estimations';
342+
COMMENT ON SUBSCRIPTION alltables IS 'Subscription for all operations on all tables';
339343
COMMENT ON TABLE my_schema.my_table IS 'Employee Information';
340344
COMMENT ON TABLESPACE my_tablespace IS 'Tablespace for indexes';
341345
COMMENT ON TEXT SEARCH CONFIGURATION my_config IS 'Special word filtering';

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp