Re: Case sensitivity problems with user name

Yes, that worked, thanks.

After also doing this:

alter database "mickey" rename to "Mickey";

it solved the problem.

Pardon my newness to Postgres.

-Will


-----Original Message-----
From: John R Pierce [mailto:pierce@hogranch.com]
Sent: 24 March 2009 16:21
To: Will Rutherdale (rutherw)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Case sensitivity problems with user name

Will Rutherdale (rutherw) wrote:
> When I try going into psql as user postgres to change the user name, I

> get this problem:
>
> postgres=# alter user mickey rename to Mickey;
>
> ERROR: role "mickey" already exists
>

you might try...

alter user "mickey" rename to "Mickey";