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

Commit6f8f9c2

Browse files
committed
Clarify which relkinds accept column comments.
Per discussion with Josh Kupershmidt.
1 parent65c033c commit6f8f9c2

File tree

1 file changed

+5
-2
lines changed

1 file changed

+5
-2
lines changed

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

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -24,9 +24,9 @@ PostgreSQL documentation
2424
COMMENT ON
2525
{
2626
TABLE <replaceable class="PARAMETER">object_name</replaceable> |
27-
COLUMN <replaceable class="PARAMETER">table_name</replaceable>.<replaceable class="PARAMETER">column_name</replaceable> |
2827
AGGREGATE <replaceable class="PARAMETER">agg_name</replaceable> (<replaceable class="PARAMETER">agg_type</replaceable> [, ...] ) |
2928
CAST (<replaceable>source_type</replaceable> AS <replaceable>target_type</replaceable>) |
29+
COLUMN <replaceable class="PARAMETER">relation_name</replaceable>.<replaceable class="PARAMETER">column_name</replaceable> |
3030
CONSTRAINT <replaceable class="PARAMETER">constraint_name</replaceable> ON <replaceable class="PARAMETER">table_name</replaceable> |
3131
CONVERSION <replaceable class="PARAMETER">object_name</replaceable> |
3232
DATABASE <replaceable class="PARAMETER">object_name</replaceable> |
@@ -86,7 +86,7 @@ COMMENT ON
8686
<variablelist>
8787
<varlistentry>
8888
<term><replaceable class="parameter">object_name</replaceable></term>
89-
<term><replaceable class="parameter">table_name.column_name</replaceable></term>
89+
<term><replaceable class="parameter">relation_name</replaceable>.<replaceable>column_name</replaceable></term>
9090
<term><replaceable class="parameter">agg_name</replaceable></term>
9191
<term><replaceable class="parameter">constraint_name</replaceable></term>
9292
<term><replaceable class="parameter">function_name</replaceable></term>
@@ -99,6 +99,9 @@ COMMENT ON
9999
aggregates, domains, functions, indexes, operators, operator classes,
100100
operator families, sequences, text search objects, types, and views can
101101
be schema-qualified.
102+
When commenting on a column,
103+
<replaceable class="parameter">relation_name</replaceable> must refer
104+
to a table, view, or composite types.
102105
</para>
103106
</listitem>
104107
</varlistentry>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp