Re: [GENERAL] list of roles

Hi / Cau Pavel,

It works great / funguje vyborne

Alain

On Dec 8, 2007 1:38 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:

> On 08/12/2007, Alain Roger <raf.news@gmail.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
>

-- 
Alain
------------------------------------
Windows XP SP2
PostgreSQL 8.2.4 / MS SQL server 2005
Apache 2.2.4
PHP 5.2.4
C# 2005-2008