Drop multiple roles

From: Julien <julien(at)sgme(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Drop multiple roles
Date: 2011-09-13 15:40:24
Message-ID: 20110913154024.GC29506@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,

I would like to drop multiple roles via SQL.

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.

Is there any clean way to do this with SQL or do I have to make a script ?

Thanks,
--
Julien

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Carlo Ascani 2011-09-13 16:59:24 Re: Drop multiple roles
Previous Message Merlin Moncure 2011-09-13 15:12:29 Re: PQisBusy() always busy