diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2012-03-22 02:08:25 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2012-03-22 02:08:25 -0400 |
| commit | 04dfc8774966c60e4031ab5d8eeb3263d9568ad3 (patch) | |
| tree | 06f98729c5d358b707d48d2470bd7ccce0a8745f /doc/src | |
| parent | f2386d7136dacbb8bf59ebbe8e5c5b73db202813 (diff) | |
| download | postgresql-04dfc8774966c60e4031ab5d8eeb3263d9568ad3.tar.gz postgresql-04dfc8774966c60e4031ab5d8eeb3263d9568ad3.zip | |
If a role has a password expiration date, show that in psql's \du output.
Per a suggestion from Euler Taveira, it seems like a good idea to include
this information in \du (and \dg) output. This costs nothing for people
who are not using the VALID UNTIL feature, while for those who are, it's
rather critical information.
FabrÃzio de Royes Mello
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/psql-ref.sgml | 25 |
1 files changed, 16 insertions, 9 deletions
diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index fdeaea60404..9710e32dfbe 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -1267,12 +1267,15 @@ testdb=> <term><literal>\dg[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> - Lists database roles. If <replaceable - class="parameter">pattern</replaceable> is specified, only - those roles whose names match the pattern are listed. - (This command is now effectively the same as <literal>\du</literal>). + Lists database roles. + (Since the concepts of <quote>users</> and <quote>groups</> have been + unified into <quote>roles</>, this command is now equivalent to + <literal>\du</literal>.) + If <replaceable class="parameter">pattern</replaceable> is specified, + only those roles whose names match the pattern are listed. If the form <literal>\dg+</literal> is used, additional information - is shown about each role, including the comment for each role. + is shown about each role; currently this adds the comment for each + role. </para> </listitem> </varlistentry> @@ -1421,11 +1424,15 @@ testdb=> <term><literal>\du[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> - Lists database roles. If <replaceable - class="parameter">pattern</replaceable> is specified, only - those roles whose names match the pattern are listed. + Lists database roles. + (Since the concepts of <quote>users</> and <quote>groups</> have been + unified into <quote>roles</>, this command is now equivalent to + <literal>\dg</literal>.) + If <replaceable class="parameter">pattern</replaceable> is specified, + only those roles whose names match the pattern are listed. If the form <literal>\du+</literal> is used, additional information - is shown about each role, including the comment for each role. + is shown about each role; currently this adds the comment for each + role. </para> </listitem> </varlistentry> |