DROP PROFILE

DROP PROFILE — remove an authentication profile

Synopsis

DROP PROFILE [ IF EXISTS ] name [, ...]

Description

The DROP PROFILE command removes the specified profile(s). You must be a database superuser or have the privileges of the pg_manage_profiles role to use this command.

A profile cannot be removed if it is still referenced in any database of the cluster; if this is the case, an error is raised. Before dropping the profile, you must drop all the roles to which it is assigned, or assign another profile to them. Use the ALTER ROLE command if you need to reassign the profile.

Parameters

IF EXISTS

Do not throw an error if the profile does not exist. A notice is issued in this case.

name

The name of the profile to remove.

Examples

Drop the specified profile:

DROP PROFILE admin_profile;