Khangelani Gama, 26.05.2014 09:20:
> Hi
>
> Something wrong happened in our server, for some strange and unknown reason (s) the server created another DB,
> there is two same DB names in one server.
>
> Name | Owner | Encoding
> ---------+----------+----------
> a9004 | postgres | UNICODE
> a9004 | postgres | UNICODE
>
Maybe there are some trailing spaces at one of the names.
What do you see when you run this:
select '"'||datname||'"' as name
from pg_database
By adding the quotes, you can see if there are any trailing (or leading) in the name.
Regards
Thomas