Re: postgreSQL : duplicate DB names - Mailing list pgsql-general

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