DROP PROFILE
DROP PROFILE — remove an authentication profile
Synopsis
DROP PROFILE [ IF EXISTS ]nameDescription
TheDROP PROFILE command removes the specified profile. You must be a database superuser 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 theALTER ROLE command if you need to reassign the profile.
Parameters
IF EXISTSDo not throw an error if the profile does not exist. A notice is issued in this case.
nameThe name of the profile to remove.
Examples
Drop the specified profile:
DROP PROFILE admin_profile;