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

Commitc82d415

Browse files
committed
Sort COMMENT synopsis and add more examples
Josh Kupershmidt
1 parentea6eda6 commitc82d415

File tree

1 file changed

+6
-2
lines changed

1 file changed

+6
-2
lines changed

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

Lines changed: 6 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -23,11 +23,10 @@ PostgreSQL documentation
2323
<synopsis>
2424
COMMENT ON
2525
{
26-
TABLE <replaceable class="PARAMETER">object_name</replaceable> |
27-
COLUMN <replaceable class="PARAMETER">table_name</replaceable>.<replaceable class="PARAMETER">column_name</replaceable> |
2826
AGGREGATE <replaceable class="PARAMETER">agg_name</replaceable> (<replaceable class="PARAMETER">agg_type</replaceable> [, ...] ) |
2927
CAST (<replaceable>source_type</replaceable> AS <replaceable>target_type</replaceable>) |
3028
COLLATION <replaceable class="PARAMETER">object_name</replaceable> |
29+
COLUMN <replaceable class="PARAMETER">table_name</replaceable>.<replaceable class="PARAMETER">column_name</replaceable> |
3130
CONSTRAINT <replaceable class="PARAMETER">constraint_name</replaceable> ON <replaceable class="PARAMETER">table_name</replaceable> |
3231
CONVERSION <replaceable class="PARAMETER">object_name</replaceable> |
3332
DATABASE <replaceable class="PARAMETER">object_name</replaceable> |
@@ -47,6 +46,7 @@ COMMENT ON
4746
SCHEMA <replaceable class="PARAMETER">object_name</replaceable> |
4847
SEQUENCE <replaceable class="PARAMETER">object_name</replaceable> |
4948
SERVER <replaceable class="PARAMETER">object_name</replaceable> |
49+
TABLE <replaceable class="PARAMETER">object_name</replaceable> |
5050
TABLESPACE <replaceable class="PARAMETER">object_name</replaceable> |
5151
TEXT SEARCH CONFIGURATION <replaceable class="PARAMETER">object_name</replaceable> |
5252
TEXT SEARCH DICTIONARY <replaceable class="PARAMETER">object_name</replaceable> |
@@ -265,8 +265,11 @@ COMMENT ON CAST (text AS int4) IS 'Allow casts from text to int4';
265265
COMMENT ON COLLATION "fr_CA" IS 'Canadian French';
266266
COMMENT ON COLUMN my_table.my_column IS 'Employee ID number';
267267
COMMENT ON CONVERSION my_conv IS 'Conversion to UTF8';
268+
COMMENT ON CONSTRAINT bar_col_cons ON bar IS 'Constrains column col';
268269
COMMENT ON DATABASE my_database IS 'Development Database';
269270
COMMENT ON DOMAIN my_domain IS 'Email Address Domain';
271+
COMMENT ON EXTENSION hstore IS 'implements the hstore data type';
272+
COMMENT ON FOREIGN DATA WRAPPER mywrapper IS 'my foreign data wrapper';
270273
COMMENT ON FOREIGN TABLE my_foreign_table IS 'Employee Information in other database';
271274
COMMENT ON FUNCTION my_function (timestamp) IS 'Returns Roman Numeral';
272275
COMMENT ON INDEX my_index IS 'Enforces uniqueness on employee ID';
@@ -280,6 +283,7 @@ COMMENT ON ROLE my_role IS 'Administration group for finance tables';
280283
COMMENT ON RULE my_rule ON my_table IS 'Logs updates of employee records';
281284
COMMENT ON SCHEMA my_schema IS 'Departmental data';
282285
COMMENT ON SEQUENCE my_sequence IS 'Used to generate primary keys';
286+
COMMENT ON SERVER myserver IS 'my foreign server';
283287
COMMENT ON TABLE my_schema.my_table IS 'Employee Information';
284288
COMMENT ON TABLESPACE my_tablespace IS 'Tablespace for indexes';
285289
COMMENT ON TEXT SEARCH CONFIGURATION my_config IS 'Special word filtering';

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp