CREATE ACCESS METHOD bloom TYPE INDEX HANDLER blhandler;

COMMENTON ACCESS METHOD bloom IS'bloom index access method';

<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> |

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>

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';

</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>

;

comment_type:

COLUMN{$$ = OBJECT_COLUMN; }

ACCESSMETHOD{$$ = OBJECT_ACCESS_METHOD; }

|COLUMN{$$ = OBJECT_COLUMN; }

|DATABASE{$$ = OBJECT_DATABASE; }

|SCHEMA{$$ = OBJECT_SCHEMA; }

|INDEX{$$ = OBJECT_INDEX; }

success=listTables("tvmsE",NULL,show_verbose,show_system);

break;

case'A':

success=describeAccessMethods(pattern,show_verbose);

break;

case'a':

success=describeAggregates(pattern,show_verbose,show_system);

break;

return true;

}

describeAccessMethods(constchar*pattern,boolverbose)

{

PQExpBufferDatabuf;

PGresult*res;

printQueryOptmyopt=pset.popt;

staticconstbooltranslate_columns[]= {false, true, false};

if (pset.sversion<90600)

{

psql_error("The server (version %d.%d) does not support access methods.\n",

pset.sversion /10000, (pset.sversion /100) %100);

return true;

}

initPQExpBuffer(&buf);

printfPQExpBuffer(&buf,

" END AS \"%s\"",

gettext_noop("Name"),

gettext_noop("Index"),

gettext_noop("Type"));

if (verbose)

{

appendPQExpBuffer(&buf,

" pg_catalog.obj_description(oid, 'pg_am') AS \"%s\"",

gettext_noop("Handler"),

gettext_noop("Description"));

}

appendPQExpBufferStr(&buf,

"\nFROM pg_catalog.pg_am\n");

processSQLNamePattern(pset.db,&buf,pattern, false, false,

NULL,"amname",NULL,

NULL);

appendPQExpBufferStr(&buf,"ORDER BY 1;");

res=PSQLexec(buf.data);

termPQExpBuffer(&buf);

if (!res)

return false;

myopt.nullPrint=NULL;

myopt.title=_("List of access methods");

myopt.translate_header= true;

myopt.translate_columns=translate_columns;

myopt.n_translate_columns=lengthof(translate_columns);

printQuery(res,&myopt,pset.queryFout, false,pset.logfile);

PQclear(res);

return true;

}

externbooldescribeAggregates(constchar*pattern,boolverbose,boolshowSystem);

externbooldescribeAccessMethods(constchar*pattern,boolverbose);

externbooldescribeTablespaces(constchar*pattern,boolverbose);

fprintf(output,_(" \\d[S+] list tables, views, and sequences\n"));

fprintf(output,_(" \\d[S+] NAME describe table, view, sequence, or index\n"));

fprintf(output,_(" \\da[S] [PATTERN] list aggregates\n"));

fprintf(output,_(" \\dA[+] [PATTERN] list access methods\n"));

fprintf(output,_(" \\db[+] [PATTERN] list tablespaces\n"));

fprintf(output,_(" \\dc[S+] [PATTERN] list conversions\n"));

fprintf(output,_(" \\dC[+] [PATTERN] list casts\n"));

staticconstchar*constbackslash_commands[]= {

"\\a","\\connect","\\conninfo","\\C","\\cd","\\copy",

"\\copyright","\\crosstabview",

"\\d","\\da","\\db","\\dc","\\dC","\\dd","\\ddp","\\dD",

"\\d","\\da","\\dA","\\db","\\dc","\\dC","\\dd","\\ddp","\\dD",

"\\des","\\det","\\deu","\\dew","\\dE","\\df",

"\\dF","\\dFd","\\dFp","\\dFt","\\dg","\\di","\\dl","\\dL",

"\\dm","\\dn","\\do","\\dO","\\dp","\\drds","\\ds","\\dS",

elseif (Matches2("COMMENT","ON"))

{

staticconstchar*constlist_COMMENT[]=

{"CAST","COLLATION","CONVERSION","DATABASE","EVENT TRIGGER","EXTENSION",

{"ACCESS METHOD","CAST","COLLATION","CONVERSION","DATABASE",

"EVENT TRIGGER","EXTENSION",

"FOREIGN DATA WRAPPER","FOREIGN TABLE",

"SERVER","INDEX","LANGUAGE","POLICY","RULE","SCHEMA","SEQUENCE",

"TABLE","TYPE","VIEW","MATERIALIZED VIEW","COLUMN","AGGREGATE","FUNCTION",

COMPLETE_WITH_LIST(list_COMMENT);

}

elseif (Matches4("COMMENT","ON","ACCESS","METHOD"))

COMPLETE_WITH_QUERY(Query_for_list_of_access_methods);

elseif (Matches3("COMMENT","ON","FOREIGN"))

COMPLETE_WITH_LIST2("DATA WRAPPER","TABLE");

elseif (Matches4("COMMENT","ON","TEXT","SEARCH"))

elseif (Matches5("DROP","TRIGGER",MatchAny,"ON",MatchAny))

COMPLETE_WITH_LIST2("CASCADE","RESTRICT");

elseif (Matches2("DROP","ACCESS"))

COMPLETE_WITH_CONST("METHOD");

elseif (Matches3("DROP","ACCESS","METHOD"))

COMPLETE_WITH_QUERY(Query_for_list_of_access_methods);

elseif (Matches2("DROP","EVENT"))

COMPLETE_WITH_CONST("TRIGGER");

}

elseif (TailMatchesCS1("\\da*"))

COMPLETE_WITH_SCHEMA_QUERY(Query_for_list_of_aggregates,NULL);

elseif (TailMatchesCS1("\\dA*"))

COMPLETE_WITH_QUERY(Query_for_list_of_access_methods);

elseif (TailMatchesCS1("\\db*"))

COMPLETE_WITH_QUERY(Query_for_list_of_tablespaces);

elseif (TailMatchesCS1("\\dD*"))