Database name with semicolon

From: Joby John <Joby(dot)John(at)nccgroup(dot)trust>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Database name with semicolon
Date: 2018-06-27 13:22:33
Message-ID: 2b0a3c93173a4bef8117c897bcca6957@MANDBSEXCH03.nccgroup.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

We have a windows application which communicate to Postgres database via PostgreSQL ODBC drivers for windows.
One of our customers has a database with semicolon in its name (e.g.: "db; name") and our application is failing to establish connection to that database saying like it could not find the database.
We tried all known possibilities by enclosing the DB name under quotes, curly brackets etc. but none solved the problem.

I wonder whether there is any possible way to achieve connection to such database. If not, probably it's better not to support semicolons within the database name.
Not sure whether I need to submit this query as a bug or not. Any help is much appreciated.

Thanks and Regards,
Joby John
________________________________
Joby John
Software Developer
NCC Group
Kings Court, Kingston Road, Leatherhead, KT22 7SL

Telephone: +44 1372 383 800<tel:+44%201372%20383%20800>
Mobile: <tel:>
Website: www.nccgroup.trust<http://www.nccgroup.trust>
Twitter: @NCCGroupplc<https://twitter.com/NCCGroupplc>
[https://www.nccgroup.trust/static/img/emaillogo/ncc-group-logo.png] <http://www.nccgroup.trust/>
________________________________

This email is sent for and on behalf of NCC Group. NCC Group is the trading name of NCC Services Limited (Registered in England CRN: 2802141). The ultimate holding company is NCC Group plc (Registered in England CRN: 4627044). This email may be confidential and/or legally privileged.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Edson Carlos Ericksson Richter 2018-06-27 14:02:19 Re: We find few queries running three times simultaneously with same parameters on postgres db
Previous Message Adrian Klaver 2018-06-27 13:17:25 Re: Example setup for Odyssey connection pooler?