<varlistentry>

<term><literal>\l</literal> (or <literal>\list</literal>)</term>

<term><literal>\l+</literal> (or <literal>\list+</literal>)</term>

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

<listitem>

<para>

List the names, owners, character set encodings, and access privileges

of all the databases in the server.

List the databases in the server and show their names, owners,

character set encodings, and access privileges.

If <replaceable class="parameter">pattern</replaceable> is specified,

only databases whose names match the pattern are listed.

If <literal>+</literal> is appended to the command name, database

sizes, default tablespaces, and descriptions are also displayed.

(Size information is only available for databases that the current

}

elseif (strcmp(cmd,"l")==0||strcmp(cmd,"list")==0)

success=listAllDbs(false);

elseif (strcmp(cmd,"l+")==0||strcmp(cmd,"list+")==0)

success=listAllDbs(true);

elseif (strcmp(cmd,"l")==0||strcmp(cmd,"list")==0||

strcmp(cmd,"l+")==0||strcmp(cmd,"list+")==0)

{

char*pattern;

boolshow_verbose;

pattern=psql_scan_slash_option(scan_state,

OT_NORMAL,NULL, true);

show_verbose=strchr(cmd,'+') ? true : false;

success=listAllDbs(pattern,show_verbose);

if (pattern)

free(pattern);

}

listAllDbs(boolverbose)

listAllDbs(constchar*pattern,boolverbose)

{

PGresult*res;

PQExpBufferDatabuf;

if (verbose&&pset.sversion >=80000)

appendPQExpBuffer(&buf,

" JOIN pg_catalog.pg_tablespace t on d.dattablespace = t.oid\n");

if (pattern)

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

NULL,"d.datname",NULL,NULL);

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

res=PSQLexec(buf.data, false);

termPQExpBuffer(&buf);

externboollistTSTemplates(constchar*pattern,boolverbose);

externboollistAllDbs(boolverbose);

externboollistAllDbs(constchar*pattern,boolverbose);

externboollistTables(constchar*tabtypes,constchar*pattern,boolverbose,boolshowSystem);

fprintf(output,_(" \\dE[S+] [PATTERN] list foreign tables\n"));

fprintf(output,_(" \\dx[+] [PATTERN] list extensions\n"));

fprintf(output,_(" \\dy [PATTERN] list event triggers\n"));

fprintf(output,_(" \\l[+]list all databases\n"));

fprintf(output,_(" \\l[+][PATTERN] list databases\n"));

fprintf(output,_(" \\sf[+] FUNCNAME show a function's definition\n"));

fprintf(output,_(" \\z [PATTERN] same as \\dp\n"));

fprintf(output,"\n");

if (!options.no_psqlrc)

process_psqlrc(argv[0]);

success=listAllDbs(false);

success=listAllDbs(NULL,false);

PQfinish(pset.db);

exit(success ?EXIT_SUCCESS :EXIT_FAILURE);

}