Shivender Devarakonda <shivenderd@gmail.com> writes:
> When I did the psql -l I see the following DBs in my local environment:
> C:\PostgreSQL\bin>psql -l
> List of databases
> Name | Owner | Encoding
> -----------+----------+-----------
> cmdb | admin | UTF8
> postgres | postgres | SQL_ASCII
> template0 | postgres | SQL_ASCII
> template1 | postgres | SQL_ASCII
> I am using cmdb which is UTF8.
Hmm, but which database did you connect to when you set the user's
password?
regards, tom lane