Re: Drop multiple roles

From: Carlo Ascani <carlo(dot)ascani(at)2ndquadrant(dot)it>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Drop multiple roles
Date: 2011-09-13 16:59:24
Message-ID: 20110913185924.0eca0fb8@2ndquadrant.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Tue, 13 Sep 2011 17:40:24 +0200
Julien <julien(at)sgme(dot)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(dot)ascani(at)2ndQuadrant(dot)it - www.2ndQuadrant.it

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2011-09-13 17:17:23 Re: Drop multiple roles
Previous Message Julien 2011-09-13 15:40:24 Drop multiple roles