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
