diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2016-06-07 17:59:34 -0400 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2016-06-07 17:59:34 -0400 |
| commit | 4f04b66f97f0e0265489f0fe0373ea44c9ad11bf (patch) | |
| tree | ca0082bb0011ef27c5f483f5088e2eadadaea4a6 /doc/src | |
| parent | 77ba610805e7ef9ba9c9a593ea8b1ca8f98f8bcb (diff) | |
Fix loose ends for SQL ACCESS METHOD objects
COMMENT ON ACCESS METHOD was missing; add it, along psql tab-completion
support for it.
psql was also missing a way to list existing access methods; the new \dA
command does that.
Also add tab-completion support for DROP ACCESS METHOD.
Author: Michael Paquier
Discussion: https://www.postgresql.org/message-id/CAB7nPqTzdZdu8J7EF8SXr_R2U5bSUUYNOT3oAWBZdEoggnwhGA@mail.gmail.com
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> |