Tuesday, November 15, 2011

Postgresql - Displaying Role Attributes

From man psql


\du[+] [ pattern ]
Lists database roles. If pattern is specified, only those roles whose names match the
pattern are listed. If the form \du+ is used, additional information is shown about each
role, including the comment for each role.


For instance:



switch_store=# \du+
Lista de roles
Nombre de rol | Atributos | Miembro de | DescripciĆ³n
---------------+-----------------------------------+------------+-------------
curso_sql | Superusuario, Crear BD | {} |

No comments:

Post a Comment