Re: Drop user cascade - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Drop user cascade
Date
Msg-id nu7jae$3bu$1@blaine.gmane.org
Whole thread Raw
In response to Drop user cascade  ("Alex Ignatov \(postgrespro\)" <a.ignatov@postgrespro.ru>)
Responses Re: Drop user cascade  ("Alex Ignatov \(postgrespro\)" <a.ignatov@postgrespro.ru>)
List pgsql-general
Alex Ignatov (postgrespro) schrieb am 19.10.2016 um 12:26:
> Hello!
>
> Why we can DROP TABLE CASCADE, DROP VIEW CASCADE, DROP SEQUENCE CASCADE but we can’t DROP USER/ROLE CASCADE?
>
> Why do Postgres have no such functionality as DROP USER CASCADE? Is there any reasons in that absence?

You can do

  drop owned by user_name;
  drop user user_name;

Thomas

pgsql-general by date:

Previous
From: "Alex Ignatov \(postgrespro\)"
Date:
Subject: Drop user cascade
Next
From: "Alex Ignatov \(postgrespro\)"
Date:
Subject: Re: Drop user cascade