Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group