Hi,
I get:
name
--------------
"a9004"
"template1"
"template0"
"a9004"
(4 rows)
-----Original Message-----
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Thomas Kellerer
Sent: Monday, May 26, 2014 9:42 AM
To: pgsql-general@postgresql.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@postgresql.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.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
