<term><literal>\dL[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term>

<listitem>

<para>

Listsallprocedural languages. If <replaceable

Lists procedural languages. If <replaceable

class="parameter">pattern</replaceable>

is specified, only languages whose names match the pattern are listed.

By default, only user-created languages

<varlistentry>

<term><literal>\dO[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term>

<listitem>

<para>

Lists collations.

listed. By default, only user-created objects are shown;

supply a pattern or the <literal>S</literal> modifier to

include system objects. If <literal>+</literal> is appended

to the command name, eachobject is listed with its associated

to the command name, eachcollation is listed with its associated

description, if any.

Note that only collations usable with the current database's encoding

are shown, so the results may vary in different databases of the

same installation.

</para>

</listitem>

</varlistentry>

listCollations(constchar*pattern,boolverbose,boolshowSystem)

if (verbose)

appendPQExpBuffer(&buf,

",\n pg_catalog.obj_description(c.oid, 'pg_collation') AS \"%s\"",

",\npg_catalog.obj_description(c.oid, 'pg_collation') AS \"%s\"",

gettext_noop("Description"));

appendPQExpBuffer(&buf,

"WHERE n.oid = c.collnamespace\n");

if (!showSystem&& !pattern)

appendPQExpBuffer(&buf," AND n.nspname <> 'pg_catalog'\n"

" AND n.nspname <> 'information_schema'\n");

appendPQExpBuffer(&buf," AND c.collencoding IN (-1, pg_catalog.pg_char_to_encoding(pg_catalog.getdatabaseencoding()))\n");

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

"n.nspname","c.collname",NULL,

"pg_catalog.pg_collation_is_visible(c.oid)");