Re: Drop multiple roles - Mailing list pgsql-novice

From Carlo Ascani
Subject Re: Drop multiple roles
Date
Msg-id 20110913185924.0eca0fb8@2ndquadrant.it
Whole thread Raw
In response to Drop multiple roles  (Julien <julien@sgme.com>)
List pgsql-novice
On Tue, 13 Sep 2011 17:40:24 +0200
Julien <julien@sgme.com> wrote:

> Hello,
>
> I would like to drop multiple roles via SQL.

You could use commas, if they are a reasonable number.

>
> I can figure how to list my specific roles with a select on pg_roles
> but deleting these roles from pg_roles is probably not a good
> solution.
>

Definitely not ;)



>
> Thanks,



--
 Carlo Ascani - 2ndQuadrant Italia
 PostgreSQL Training, Services and Support
 carlo.ascani@2ndQuadrant.it - www.2ndQuadrant.it

pgsql-novice by date:

Previous
From: Julien
Date:
Subject: Drop multiple roles
Next
From: Tom Lane
Date:
Subject: Re: Drop multiple roles