DROP PROFILE — remove an authentication profile
DROP PROFILE [ IF EXISTS ]
DROP PROFILE command removes the specified profile(s). 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 the ALTER ROLE command if you need to reassign the profile.
Do not throw an error if the profile does not exist. A notice is issued in this case.
The name of the profile to remove.
Drop the specified profile:
DROP PROFILE admin_profile;