diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/comment.sgml | 4 | ||||
| -rw-r--r-- | doc/src/sgml/ref/psql-ref.sgml | 13 |
2 files changed, 17 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/comment.sgml b/doc/src/sgml/ref/comment.sgml index 3321d4b49d6..fdebbffc705 100644 --- a/doc/src/sgml/ref/comment.sgml +++ b/doc/src/sgml/ref/comment.sgml @@ -23,6 +23,7 @@ PostgreSQL documentation <synopsis> COMMENT ON { + ACCESS METHOD <replaceable class="PARAMETER">object_name</replaceable> | AGGREGATE <replaceable class="PARAMETER">aggregate_name</replaceable> ( <replaceable>aggregate_signature</replaceable> ) | CAST (<replaceable>source_type</replaceable> AS <replaceable>target_type</replaceable>) | COLLATION <replaceable class="PARAMETER">object_name</replaceable> | @@ -89,6 +90,8 @@ COMMENT ON Roles don't have owners, so the rule for <literal>COMMENT ON ROLE</> is that you must be superuser to comment on a superuser role, or have the <literal>CREATEROLE</> privilege to comment on non-superuser roles. + Likewise, access methods don't have owners either; you must be superuser + to comment on an access method. Of course, a superuser can comment on anything. </para> @@ -296,6 +299,7 @@ COMMENT ON TABLE mytable IS NULL; Some more examples: <programlisting> +COMMENT ON ACCESS METHOD rtree IS 'R-Tree 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'; diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index 06803ab89ca..aef72284d26 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -1130,6 +1130,19 @@ testdb=> </listitem> </varlistentry> + <varlistentry> + <term><literal>\dA[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + + <listitem> + <para> + Lists access methods. If <replaceable + class="parameter">pattern</replaceable> is specified, only access + methods whose names match the pattern are shown. If + <literal>+</literal> is appended to the command name, each access + method is listed with its associated handler function and description. + </para> + </listitem> + </varlistentry> <varlistentry> <term><literal>\db[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> |