Re: VALID UNTIL

2012/3/14 David Fetter <david@fetter.org>

>
> I don't know how frequently people use VALID UNTIL, but I'm guessing
> it's not terribly often because yours is the first comment about how
> it's not exposed, so I'd tend toward putting it in attributes rather
> than a separate column.
>
>
The attached patch put VALID UNTIL into attributes column in verbose mode
like example above.

bdteste=# \du
                             List of roles
 Role name |                   Attributes                   | Member of
-----------+------------------------------------------------+-----------
 bucardo   | Superuser, Create role, Create DB, Replication | {}
 postgres  | Superuser, Create role, Create DB, Replication | {}

bdteste=# \du+
                                                          List of roles
 Role name |                                        Attributes
                            | Member of | Description
-----------+-------------------------------------------------------------------------------------------+-----------+--------------
 bucardo   | Superuser, Create role, Create DB, Valid until 2012-12-31
23:59:59.999999-02, Replication | {}        | bucardo role
 postgres  | Superuser, Create role, Create DB, Replication
                           | {}        |


Regards,

-- 
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello