Re: list of roles

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: "Alain Roger" <raf(dot)news(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: list of roles
Date: 2007-12-08 12:38:55
Message-ID: 162867790712080438g4a97fb53p1872ff675effe984@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 08/12/2007, Alain Roger <raf(dot)news(at)gmail(dot)com> wrote:
> Hi,
>
> i would like to know how can i get the complete list of roles available ?
> as i use phppgAdmin, it could be great to get it as a SQL query.
>
> thanks a lot,
>

Hello

SELECT rolname FROM pg_roles;

Regards
Pavel Stehule

> --
> Alain
> ------------------------------------
> Windows XP SP2
> PostgreSQL 8.2.3
> Apache 2.2.4
> PHP 5.2.3

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alain Roger 2007-12-08 12:54:39 Re: list of roles
Previous Message Alain Roger 2007-12-08 12:04:59 list of roles