Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit474f825

Browse files
committed
Add the new psql command \drds to the psql docs, help and tab completion.
I also thank Bernd Helmle for the documentation help on the previous settingspatch, which I forgot on the commit message.
1 parenteab94d8 commit474f825

File tree

3 files changed

+24
-4
lines changed

3 files changed

+24
-4
lines changed

‎doc/src/sgml/ref/psql-ref.sgml

Lines changed: 20 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/ref/psql-ref.sgml,v 1.230 2009/10/05 19:24:34 tgl Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/psql-ref.sgml,v 1.231 2009/10/08 16:34:00 alvherre Exp $
33
PostgreSQL documentation
44
-->
55

@@ -1265,6 +1265,25 @@ testdb=&gt;
12651265
</listitem>
12661266
</varlistentry>
12671267

1268+
<varlistentry>
1269+
<term><literal>\drds [ <replaceable class="parameter">role-pattern</replaceable> [ <replaceable class="parameter">database-pattern </replaceable> ] ]</literal></term>
1270+
<listitem>
1271+
<para>
1272+
Lists defined configuration settings. These settings can be role-specific,
1273+
database-specific, or both. <literal>role-pattern</literal> and
1274+
<literal>database-pattern</literal> are used to select
1275+
specific roles and database to list, respectively; if omitted, or * is specified,
1276+
all settings are listed, including those not role-specific or database-specific,
1277+
respectively.
1278+
</para>
1279+
1280+
<para>
1281+
The <xref linkend="sql-alterrole" endterm="sql-alterrole-title"> and
1282+
<xref linkend="sql-alterdatabase" endterm="sql-alterdatabase-title">
1283+
commands are used to define per-database role configuration settings.
1284+
</para>
1285+
</listitem>
1286+
</varlistentry>
12681287

12691288
<varlistentry>
12701289
<term><literal>\dT[S+] [ <replaceable class="parameter">pattern</replaceable> ]</literal></term>

‎src/bin/psql/help.c

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -3,7 +3,7 @@
33
*
44
* Copyright (c) 2000-2009, PostgreSQL Global Development Group
55
*
6-
* $PostgreSQL: pgsql/src/bin/psql/help.c,v 1.153 2009/10/05 19:24:46 tgl Exp $
6+
* $PostgreSQL: pgsql/src/bin/psql/help.c,v 1.154 2009/10/08 16:34:01 alvherre Exp $
77
*/
88
#include"postgres_fe.h"
99

@@ -217,6 +217,7 @@ slashUsage(unsigned short int pager)
217217
fprintf(output,_(" \\dn[+] [PATTERN] list schemas\n"));
218218
fprintf(output,_(" \\do[S] [PATTERN] list operators\n"));
219219
fprintf(output,_(" \\dp [PATTERN] list table, view, and sequence access privileges\n"));
220+
fprintf(output,_(" \\drds [PATRN1 [PATRN2]] list per-database role settings\n"));
220221
fprintf(output,_(" \\ds[S+] [PATTERN] list sequences\n"));
221222
fprintf(output,_(" \\dt[S+] [PATTERN] list tables\n"));
222223
fprintf(output,_(" \\dT[S+] [PATTERN] list data types\n"));

‎src/bin/psql/tab-complete.c

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -3,7 +3,7 @@
33
*
44
* Copyright (c) 2000-2009, PostgreSQL Global Development Group
55
*
6-
* $PostgreSQL: pgsql/src/bin/psql/tab-complete.c,v 1.185 2009/08/02 22:14:52 tgl Exp $
6+
* $PostgreSQL: pgsql/src/bin/psql/tab-complete.c,v 1.186 2009/10/08 16:34:01 alvherre Exp $
77
*/
88

99
/*----------------------------------------------------------------------
@@ -629,7 +629,7 @@ psql_completion(char *text, int start, int end)
629629
"\\a","\\connect","\\C","\\cd","\\copy","\\copyright",
630630
"\\d","\\da","\\db","\\dc","\\dC","\\dd","\\dD","\\des","\\deu","\\dew","\\df",
631631
"\\dF","\\dFd","\\dFp","\\dFt","\\dg","\\di","\\dl",
632-
"\\dn","\\do","\\dp","\\ds","\\dS","\\dt","\\dT","\\dv","\\du",
632+
"\\dn","\\do","\\dp","\\drds","\\ds","\\dS","\\dt","\\dT","\\dv","\\du",
633633
"\\e","\\echo","\\ef","\\encoding",
634634
"\\f","\\g","\\h","\\help","\\H","\\i","\\l",
635635
"\\lo_import","\\lo_export","\\lo_list","\\lo_unlink",

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp