Re: postgreSQL : duplicate DB names

Hi,

I get:

name
--------------
"a9004"
"template1"
"template0"
"a9004"
(4 rows)

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Thomas Kellerer
Sent: Monday, May 26, 2014 9:42 AM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] postgreSQL : duplicate DB names

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(at)postgresql(dot)org) To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

CONFIDENTIALITY NOTICE
The contents of and attachments to this e-mail are intended for the addressee only, and may contain the confidential
information of Argility (Proprietary) Limited and/or its subsidiaries. Any review, use or dissemination thereof by anyone
other than the intended addressee is prohibited.If you are not the intended addressee please notify the writer immediately
and destroy the e-mail. Argility (Proprietary) Limited and its subsidiaries distance themselves from and accept no liability
for unauthorised use of their e-mail facilities or e-mails sent other than strictly for business purposes.