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
 




-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to