Re: User got created with first letter capitalized

On Mon, Jul 25, 2016 at 11:51 AM, John Scalia <jayknowsunix(at)gmail(dot)com>
wrote:

> I have a user who was inserted into the db by one of our automation
> scripts. His ID has the very first letter capitalized. The script reads
> the users from the appropriate Active Directory group and makes sure they
> exist in the database.
>
> For grins, let's say the user is good old Charley Brown and is called
> "Cbrown1" in Active Directory. If I look for him by rolname in either
> pg_authid or the pg_roles view, He shows as:
>
> rolname
> -----------
> Cbrown1
> (1 row)
>
> but when I try then to get rid of him using either "DROP ROLE cbrown1;" or
> "DROP ROLE Cbrown1;" I receive "ERROR: role "cbrown1" does not exist. Note
> that I get the error with the name in all lower case regardless of which
> way I specify him.
>
> Also, he does not show up using \du Cbrown1 or \du+ cbrown1, but does show
> if I enter \du without specifying his id.
>
> Anyone know what's going on with this?
> --
> Jay
>

Surround the role name with double-quotes. Otherwise postgres converts all
object names to lowercase.

DROP ROLE "Cbrown1";

Keith