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;